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