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