=SUMIF(Q4:Q27,"0",H4:H27)+SUMIF(R4:R27,"0",H4:H2 7)

will work

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Debgala" wrote in message
...
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