Sumif with multiple sum range

Debaser · #1 10-27-2015, 01:39 AM

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

Haha88 · #2 10-28-2015, 03:38 PM

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,

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