I'm surprised that you got a #VALUE! error from that. I would have expected
to get an error reported when you tried to enter the formula, as the quote
marks don't match.
If you didn't actually use that formula, and you've mistyped it into the
newsgroup, I would suggest that in future you don't try to retype. Copy from
the formula bar and paste here.

Secondly, are you sure that you intended to use the quote marks? Are you
looking for 10 and 2008 as text strings or as numbers?
What do =ISTEXT(A2) and =ISNUMBER(A2) show, and similarly for B2?

Thirdly, your formula wouldn't work as you are using range as the name for
both columns, and you asked for the 10 in one column and the 2008 in a
different column. You need two different ranges.
--
David Biddulph

"Rebekah" wrote in message
...
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