Roger Govier Wrote:
Hi

You seem to be missing the outer set of brackets from your formula
SUMPRODUCT((Sheet1!$C$1:$C$1000=A3)*(Sheet1!$L$1:$ L$1000=B2))

--
Regards

Roger Govier




Yes, sorry, that was just a typo - doesn't help you i know so
apologies.

Zygan - that returns 0 i'm afraid. I did check with a straight forward
countif to make sure my formatting etc was exactly the same and thats
ok. This has got me pulling my hair out!


--
penri0_0


------------------------------------------------------------------------
penri0_0's Profile: http://www.excelforum.com/member.php...o&userid=28947
View this thread: http://www.excelforum.com/showthread...hreadid=548970