Using DCOUNT

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

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
 
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
 
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)
 
Back
Top