When you have multiple criteria use SUMPRODUCT()

=SUMPRODUCT((A1:A10=criteria1)*(B1:B10=criteria2))

'In your case since it is in a different sheet...with month and year in F1
and F2
=SUMPRODUCT((Sheet2!A1:A10=F1)*(sheet2!B1:B10=F2))

If this post helps click Yes
---------------
Jacob Skaria


"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