Using DCOUNT

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
 
B

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
 
A

Ashish Mathur

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top