That's because I can't either :-(

I didn't check that C1 to C65536 converted to C:C. What you did is right
.... you can't use SUMPRODUCT on a full column.

Regards


"Sloth" wrote in message
...
I tried a SUMPRODUCT using C1:C65536 and it converted to C:C and gave me an
error. I then tried C1:C65535 and it worked. Why can you do the whole
row,
but I can't?

"Trevor Shuttleworth" wrote:

SUMPRODUCT does not work on columns.

SUMPRODUCT(--(Sheet Name!$C1:$C65536="value"),--('Sheet
Name!$D1:$D65536="value"))

Regards

Trevor


"SamGB" wrote in
message ...

Cheers guys,
could you help me with this problem aswell,
im using this formula:
SUMPRODUCT(--(Sheet Name!$C:$C="value"),--('Sheet Name!$D:$D="value"))

but its coming out as product: #NUM!

Cheers


--
SamGB
------------------------------------------------------------------------
SamGB's Profile:
http://www.excelforum.com/member.php...o&userid=31263
View this thread:
http://www.excelforum.com/showthread...hreadid=516363