LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
dcount michaeldmaxey Excel Discussion (Misc queries) 2 October 29th 09 11:07 AM
DCOUNT Help Rob B. Excel Worksheet Functions 2 April 20th 09 06:48 PM
DCOUNT Help! fearthespear Excel Discussion (Misc queries) 1 November 7th 08 06:02 AM
DCount help Engels Excel Worksheet Functions 4 January 8th 07 04:18 PM
dcount with vba J Slavin Excel Worksheet Functions 2 March 26th 06 05:01 PM


All times are GMT +1. The time now is 03:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"