SUMIFS question

[mikeolson]

I'm trying to return values from cells that the cell to the left contains specific text, and total them. I'm unsure on how to get this formula to work. I have more than one criteria that needs to be met, and totals for each of those criteria.

=SUMIFS(B36:B43,A36:A43, "TURN", SUMIFS(F36:F43,E36:E43, "TURN", SUMIFS(J36:J43, I36:I43, "TURN")))

This formula would be in a cell next to TURN. I have a copy saved that I can upload to show you.

 

[TheRobRush]

for example, if you had six column A-E

and hose 6 columns A C and E randomly contained the word turn

while B D and F had numbers

the formula would be a follows

=SUMIF(A2:A6,"TURN",B2:B6)+SUMIF(C2:C6,"TURN",D2:D6)+SUMIF(E2:E6,"TURN",F2:F6)

can also put *turn* for ones that are not ONLY turn but like a phrase containing it

 

[mikeolson]

for example, if you had six column A-E

and hose 6 columns A C and E randomly contained the word turn

while B D and F had numbers

the formula would be a follows

=SUMIF(A2:A6,"TURN",B2:B6)+SUMIF(C2:C6,"TURN",D2:D6)+SUMIF(E2:E6,"TURN",F2:F6)

can also put *turn* for ones that are not ONLY turn but like a phrase containing it

Thank you, that's perfect!