Really?

Mine and Domenic's can't both work like a charm, as they will return
different results. Mine is an AND condition, Domenic's is an OR. If say Q4
and R4 are 0, mine will add H4 twice, Domenic's just once.

--

HTH

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


"Debgala" wrote in message
...
Thanks Bob - it works like a charm.

"Bob Phillips" wrote:

=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