Thread: Using DCOUNT
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Using DCOUNT

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