want sumif function's range to evaluate 2 columns
From just looking at your formula, I could guess that you want *both*
Columns Q & R to be greater then zero before adding the value in Column H.
However, I did say *guess*.
Could it also be Q *OR* R greater then zero?
So, is it Q *AND* R
Or is it Q *OR* R ?
And which way should Sumif() translate it?
Q *and* R
=SUMPRODUCT((Q4:Q270)*(R4:R270)*H4:H27)
Q *or* R
=SUMPRODUCT(((Q4:Q270)+(R4:R270)0)*H4:H27)
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"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
|