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