Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif with multiple critera range and sum_range
Hello,
I have a worksheet where I'm trying to use the sumif function to sum over multiple criteria ranges and multiple sum_ranges. The following formula, which shows three ranges, (surprisingly) works. Is there a more compact way to implement this? This is for a budget spreadsheet where each of the ranges (J31:J36 for example, are one month. So the full scale formula would have 12 ranges and sum_ranges. Notice that the sum_ranges are offset two columns right of the critera range. =SUMIF(($J$31:$J$36:$O$31:$O$36:$T$31:$T$36),"="&C 47,($L$31:$L$36:$Q$31:$Q$36:$V$31:$V$36)) If I rearranged the columns, would it that make it possible for a more compact formula to work? Thanks, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif with multiple columns in sum_range | Excel Discussion (Misc queries) | |||
Sumif with multiple columns in sum_range | Excel Worksheet Functions | |||
SUMIF when using a range with critera | Excel Discussion (Misc queries) | |||
SUMIF when using a range with critera | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |