#1
|
|||
|
|||
Sumif with multiple sum range
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, |
#2
|
||||
|
||||
Perhaps = sum(b6:j10)-sum(b7:J7) ?
__________________
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 |
#3
|
|||
|
|||
Many thanks for looking into this but that's not I what need...
|
#4
|
||||
|
||||
Care to be a bit more specific?
__________________
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 |
#5
|
||||
|
||||
What do you need? How would a formula know to sum those rows and not row 7?
|
#6
|
|||
|
|||
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, |
#7
|
|||
|
|||
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? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
multiple criteria and within a range? | hhppyy | Excel | 1 | 07-17-2015 08:17 AM |
SUMIF not working across multiple columns | SteveBump | Excel | 3 | 05-14-2015 07:06 AM |
SUMIF/SUMPRODUCT across multiple sheets/Criterias | lukeyb_11 | Excel | 1 | 02-14-2014 10:30 AM |
Using range object to work with multiple columns | kjworduser | Word VBA | 1 | 11-01-2013 03:03 AM |
Multiple criteria in SUMIF? | pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |