Sum with multiple criteria problem

[NV]

Thank you to anyone who can help me with this! I use this
function in several different places, yet this is the only
one that doesn't give me the correct answer.....


=SUM((($H$4:$H$75>B79)*($E$4:$E$75<=B79)*($E$4:$E$75>0)
*$G$4:$G$75))

Any ideas on why this formula would deliver an incorrect
answer in one particular place, but correctly on other
pages? TIA!

 

[Frank Kabel]

Hi
try (array entered):
=SUM(($H$4:$H$75>B79)*($E$4:$E$75<=B79)*($E$4:$E$75>0)*($G$4:$G$75))

or use SUMPRODUCT for this 8not array entered):
=SUMPRODUCT(--($H$4:$H$75>B79),--($E$4:$E$75<=B79),--($E$4:$E$75>0),$G$
4:$G$75)

 

[Ken Wright]

Is one array entered and one not (Curly braces around the formula will indicate
being array entered)

If not array entered, hit F2 then CTRL+SHIFT+ENTER