this thing ahs been bugging me for quite some time . Hope that someone
can help me!


i tried to use sumproduct to calculate the sum of a product based on a
few criteria but the result i got is ZERO.

the formula is
SUMPRODUCT(--($E$2:$E$11=4086),--($B2:$B$11="Oct"),--($J$2:$J$11="Domestic"),$H$2:$H$11)

4086 is a number i want to find . Both the Oct and Domestic are
descriptions


--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=485796