D
DocBrown
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),"="&C47,($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
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),"="&C47,($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