Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple criteria in dcount
Database:
a b c 1 Name sold due 2 Bob 1/1/01 FY05q2 3 Bob FY05q4 4 Bob 3/15/02 FY05q1 5 Sally 3/15/03 FY05q4 6 Sally FY05q4 7 Mike FY05q1 Hopefully, the DCOUNT matrix of column b that counts the non-blank cells: due due due due FY05q1 FY05q2 FY05q3 FY05q4 name Bob 1 1 0 0 name Sally 0 0 0 1 name Mike 0 0 0 0 Can you have multiple criteria in the formula such as =dcount(a1:c7,"sold",c1:c2#and#a100:b100) for Bob FY05q1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Dynamic Criteria with DCOUNT/DSUM | Excel Worksheet Functions | |||
Excel Dcount multiple criteria | Excel Discussion (Misc queries) | |||
Dcount with Multiple Criteria | Excel Worksheet Functions | |||
Using ADD function within DCOUNT criteria | Excel Discussion (Misc queries) | |||
DSUM and DCount when criteria values are similar | Excel Worksheet Functions |