Sumif with multiple sum range

		Microsoft Office Forums > Microsoft Excel > Excel
Sumif with multiple sum range

FAQ

Thread Tools

Display Modes

10-28-2015, 03:38 PM

Haha88

Windows 8

Office 2010 32bit

Advanced Beginner

Join Date: Mar 2015

Posts: 79

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,

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:14 AM.