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 |
All times are GMT +1. The time now is 10:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com