Forum Discussion

priddlel's avatar
priddlel
Copper Contributor
Aug 29, 2022

SUMIFS formula help - multi-criteria settings not correct.

I have a multi-sheet budget spreadsheet at work.     I am trying to total the spend for each department based on a selection of account codes.i.e: total spend of all "Marketing" codes...
excel
Formulas and Functions
Harun24HR's avatar
Harun24HR
Bronze Contributor
Aug 29, 2022

priddlel You need to wrap SUMIFS() with SUM() function. Try-

=SUM(SUMIFS(C2:C13,B2:B13,F2:F4,A2:A13,E2))

Otherwise you can use SUMPRODUCT() like

=SUMPRODUCT((C2:C13)*(ISNUMBER(MATCH(B2:B13,F2:F4,0)))*(A2:A13=E2))

You can use FILTER() function if you have Microsoft 365. See the attached file.

 

Resources