You can NOT use sumproduct with entire columns.
use a1:a100
or defined named ranges
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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