You can't use entire column references in the SUMPRODUCT formula in versions
less than XL2007. Since you are using XL2003, you will have to specify the
full range...

=SUMPRODUCT((('Raw Data'!A1:A25000)=$C2)*(('Raw Data'!B1:B25000)=$I$1)*1)

You don't need that *1 in your formula as you are already multiply the other
expressions.

Rick


"Keith R" wrote in message
...
I have two worksheets in my workbook. I'm trying to get a simple sumproduct
based, but I keep getting #Num! values, and can't get my formula to work.
I'd appreciate any suggestions. using XL2003.

Sheets: Raw Data, Main

In Raw Data (about 25K rows)
A B
Item Owner

In Main: comparison Item in C, Owner in Row 1 of that column (with fake
data indicating what I want the formula to return in I2
A B C..... I J K
1 Misc Misc Item OwnerA OwnerB OwnerC
2 Car 2

I'm trying to count the number of each item that each owner has;

Everything I've seen suggests that the proper syntax is:

=SUMPRODUCT((('Raw Data'!A:A)=$C2)*(('Raw Data'!B:B)=$I$1)*1)

but that isn't returning a result (other than #NUM!)

Are there issues with using ranges on other sheets? Or using the entire
column instead of a discrete range (e.g. will blank rows kill it)?

Thanks!
Keith