Prev: Toolbar question
Next: Unable to Unlock Workbook
From: Bob on 26 Mar 2010 11:44
I have two cells containing the DCOUNT function. In the first cell, I have
set the criteria to "Post-Phase 3". In the second cell, I have set the
criteria to "Post-Phase 3 and PDU".

The DCOUNT function in the second cell is counting items that meet its own
criteria as well as the criteria used in the first DCOUNT cell . . . and I
understand why.

I need to make the second DCOUNT cell count only those items where the
criteria is "Post-Phase 3 and PDU" (but not count those items where the
criteria is "Post-Phase 3").

Any help would be greatly appreciated.

Thanks,
Bob

From: Bob Phillips on 26 Mar 2010 12:45
Shouldn't you be using DCOUNTA?

--

HTH

Bob

"Bob" <Bob(a)discussions.microsoft.com> wrote in message
news:B8F4AC7A-4C97-410C-AA50-A80F9DD4253F(a)microsoft.com...
>I have two cells containing the DCOUNT function. In the first cell, I have
> set the criteria to "Post-Phase 3". In the second cell, I have set the
> criteria to "Post-Phase 3 and PDU".
>
> The DCOUNT function in the second cell is counting items that meet its own
> criteria as well as the criteria used in the first DCOUNT cell . . . and I
> understand why.
>
> I need to make the second DCOUNT cell count only those items where the
> criteria is "Post-Phase 3 and PDU" (but not count those items where the
> criteria is "Post-Phase 3").
>
> Any help would be greatly appreciated.
>
> Thanks,
> Bob
>


From: Bob on 26 Mar 2010 16:19
Hi Bob,
Thanks for the suggestion. However, I already tried using DCOUNTA, but the
results were still incorrect.

I finally tried using ="=Post-Phase 3" and ="=Post-Phase 3 and PDU" as the
criteria for DCOUNT and the results came out correct.

Regards,
Bob


"Bob Phillips" wrote:

> Shouldn't you be using DCOUNTA?
>
> --
>
> HTH
>
> Bob
>
> "Bob" <Bob(a)discussions.microsoft.com> wrote in message
> news:B8F4AC7A-4C97-410C-AA50-A80F9DD4253F(a)microsoft.com...
> >I have two cells containing the DCOUNT function. In the first cell, I have
> > set the criteria to "Post-Phase 3". In the second cell, I have set the
> > criteria to "Post-Phase 3 and PDU".
> >
> > The DCOUNT function in the second cell is counting items that meet its own
> > criteria as well as the criteria used in the first DCOUNT cell . . . and I
> > understand why.
> >
> > I need to make the second DCOUNT cell count only those items where the
> > criteria is "Post-Phase 3 and PDU" (but not count those items where the
> > criteria is "Post-Phase 3").
> >
> > Any help would be greatly appreciated.
> >
> > Thanks,
> > Bob
> >
>
>
> .
>
From: Ashish Mathur on 26 Mar 2010 22:36
Hi,

Let's say the first cell which holds the DCOUNTA is cell G3. While on cell
G3, press F2 and and the end of the DCOUNTA function, enter -sum(G$2:G2).
So the formula will be

=your_DCOUNT_formula-sum(G$2:G2)

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Bob" <Bob(a)discussions.microsoft.com> wrote in message
news:B8F4AC7A-4C97-410C-AA50-A80F9DD4253F(a)microsoft.com...
> I have two cells containing the DCOUNT function. In the first cell, I
> have
> set the criteria to "Post-Phase 3". In the second cell, I have set the
> criteria to "Post-Phase 3 and PDU".
>
> The DCOUNT function in the second cell is counting items that meet its own
> criteria as well as the criteria used in the first DCOUNT cell . . . and I
> understand why.
>
> I need to make the second DCOUNT cell count only those items where the
> criteria is "Post-Phase 3 and PDU" (but not count those items where the
> criteria is "Post-Phase 3").
>
> Any help would be greatly appreciated.
>
> Thanks,
> Bob
>
 | 
Pages: 1
Prev: Toolbar question
Next: Unable to Unlock Workbook