Formula to make sum based on multiple conditions, HELP!

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to make sum based on multiple conditions, HELP!

11-14-2017, 06:14 AM

NBVC

Windows 10 Formula to make sum based on multiple conditions, HELP!

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

Try:

Code:

=SUMIFS(CODES!D$2:D$34,CODES!$C$2:$C$34,$B3)

copied down and across.

or if you need to also match the column headers because they may not be in consistent order, then

Code:

=SUMIFS(INDEX(CODES!$D$2:$F$34,,MATCH(C$2,CODES!$D$1:$F$1,0)),CODES!$C$2:$C$34,$B3)

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Merging 2 different cells containing IF formula & change in cell values based on multiple time frame	jay_excel	Excel	0	07-29-2017 11:04 PM
Index to return value based on 2 conditions	george batshon	Excel	2	01-28-2017 05:11 AM
How to make MATCH/INDEX formula return multiple successive responses.	danigirl121	Excel	7	06-08-2016 01:57 PM
Excel Formula for Multiple Conditions & Results	nowco	Excel	4	03-16-2016 11:24 AM
How to Subtract value in table, based on two different conditions	nitemath2	Excel	1	06-19-2015 01:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:06 PM.