If you just want to use formulae in the Results cells, this will work. Be
sure to press "ctrl/alt/Enter" since this is an array formula.

=IF(B2:B9 = "a",COUNTIF(A2:A9,"1"),0)

Just change the letters and numbers for each respective cell.
--
Best wishes,

Jim


"vumian" wrote:


hi everyone,

i have a database as following:

Date Type
1 a
1 d
1 a
2 a
2 b
3 c
3 a
3 d
..
31

Result Here
Date Count
1 ? (result is 3)
2 ? (Result is 1)
..
31

I wanna count, how many a and d are there in Date 1 ???


--
vumian
------------------------------------------------------------------------
vumian's Profile: http://www.excelforum.com/member.php...o&userid=36494
View this thread: http://www.excelforum.com/showthread...hreadid=568344