P
pjo
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
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