want sumif function's range to evaluate 2 columns
Hi,
It seems you want to sum the range if any one of columns (Q or R) have a 0.
You may also try the following array formula (Ctrl+Shift+Enter)
=sum(if((Q4:Q270)+(R4:R270),H4:H27))
Regards,
Ashish Mathur
"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
|