Assuming that you want to sum the values in Column H where the
corresponding values in Column Q or Column R are greater than zero,
try...

=SUMPRODUCT(--((Q4:Q270)+(R4:R270)0),H4:H27)

Hope this helps!

In article ,
"Debgala" wrote:

I wanted sumif to evaluate a range of cells over 2 columns.
My formula looked like this
=SUMIF(Q4:R27,"0",H4:H27)
Oddly enough, it works if there is a value 0 in column Q,
or in both columns Q and R,
but will not work if there is a value 0 in column R but no value 0 in
column Q.

How can I make it work? (And if anyone has time, why doesn't it work the
way it is now?)

Thanks,
Deb