| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
want sumif function's range to evaluate 2 columns
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count all the columns in a range with certain conditions | Excel Discussion (Misc queries) | |||
| Select updated data from a range of columns | Excel Worksheet Functions | |||
| Match function...random search? | Excel Worksheet Functions | |||
| Sum alternate columns over a large (>100) range | Excel Discussion (Misc queries) | |||
| sumif columns and rows | Excel Worksheet Functions | |||
Threaded Mode
