Hi Eduardo

Is it possible that I am getting the #VALUE result because the cells by
which I am running the formula are already products of another formula?

Many thanks

"Eduardo" wrote:

Hi,
try

=SUMPRODUCT(--($A$8:$A$10=10),--($B$8:$B$10=2008))

change range to fit your needs

"Rebekah" wrote:

I have tried =sumproduct((range = "10")*(range = "2008))

This returned #VALUE

Any other ideas?

Your reply won't work because the formulas are running from another
worksheet, and I the numbers relate to months and years...

B

"Gaffnr" wrote:

Of course, you could always do a count pivot table as well.

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