Using DCOUNT
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" wrote in message
...
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
.
|