Hi,



I'm trying to work on a sumif function but need to sum quite a few ranges. Is there any other way other than using multiple sumif together.

Please review my attachment. Any help would be very much appreciated.

Many thanks,

Attached Files

Book3.xlsx (14.0 KB, 22 views)

Perhaps = sum(b6:j10)-sum(b7:J7) ?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Many thanks for looking into this but that's not I what need...

Care to be a bit more specific?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

What do you need? How would a formula know to sum those rows and not row 7?

Hi there,

I need to pull the budget column for any particular month to include total of r6, r8-r10 (exc r7). I came up with
=sumif(b2&b4,l2,b6;j6)&sumif(b2&b4,l2,b8;j8)&sumif (b2&b4,l2,b9;j9)&sumif(b2&b4,l2,b10;j10)

I'm looking for some shorter formula to be able to pull up the same sum.

Many thanks,

For BUDNOV what's wrong with:

=SUM(B6, B8:B10)

To me it doesn't seem to give any meaning to sum B6:J6, B8:J8 etc.
Or have I completely misunderstood?