Formula to make sum based on multiple conditions, HELP!

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

ilsel Formula to make sum based on... 11-14-2017, 02:23 AM

NBVC Try: ... 11-14-2017, 06:14 AM

ilsel Thank you! It works in the... 11-14-2017, 01:55 PM

ilsel I found what I did wrong!... 11-15-2017, 02:03 AM

11-15-2017, 02:03 AM

ilsel

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

Office 2010 64bit

Novice

Join Date: Nov 2017

Posts: 3

Quote:

Originally Posted by NBVC

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)

I found what I did wrong!
Thank you so much, lifesaver.
Greets Ilse.

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