This worked for me....
Rob
x

=SUMPRODUCT(($A$1:$A$5=10)*($B$1:$B$5=2008))
--
Rob Gaffney


"Rebekah" wrote:

I'm hoping somebody can help me, as I feel this formula should be simple, but
I can't get it to work!

I have 2 columns
A B
10 2008
11 2008
10 2009

I need to count how many time column A records the occurance of "10" when
column B records the occurance of "2008".

Please help!

Beks