Countif with variable range

[mucah!t]

Hello all,

I need cell C12 to count the number of occurances of B13 ["A"] for the date mentioned in B12 [4-jan]
any ideas?

Excel Workbook
	B	C	D	E	F
4	1-Jan	A	A	B	C
5	2-Jan	C	C	A	B
6	3-Jan	C	C	C	C
7	4-Jan	B	B	A	A
8	5-Jan	C	A	B	C
9	6-Jan	A	C	C	A
10
11
12	4-Jan	2
13	A
Sheet1

Excel 2003

 

[Richard Schollar]

Perhaps:

=COUNTIF(INDEX(C4:F9,MATCH(B12,B4:B9,0),0),B13)

 

[mucah!t]

Thanks Richard!