multiple If and SUMIFS

Question

Good evening,Need help with following multiple criteria. Trying to select Department or all expenses through drop down menu. Thank youNo problem with one criteria (first statement of selecting Marketing), getting error when adding second criteria&nbsp;&nbsp; #1)=IF($B$3="Marketing",IF(D$4="Actuals",-SUMIFS('Netsuite IncomeStatement'!AD:AD,'Netsuite IncomeStatement'!$E:$E,'Departmental Income Statment'!$B$3,'Netsuite IncomeStatement'!$B:$B,'Departmental Income Statment'!$B45,,#2) IF(B3="Actuals v Plan FY26, 'Netsuite IncomeStatement'!AD:AD,'Netsuite IncomeStatement'!B:B,'Departmental Income Statment'!B45,0""))&nbsp;

nikolinode · Answer

You want:If B3 = "Marketing", run a SUMIFS with Department = MarketingIf B3 = "Actuals v Plan FY26", run a different SUMIFSOtherwise return 0=IF(&nbsp;&nbsp;&nbsp;&nbsp;$B$3="Marketing",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-SUMIFS('Netsuite IncomeStatement'!AD:AD,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Netsuite IncomeStatement'!$E:$E,$B$3,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Netsuite IncomeStatement'!$B:$B,$B45),&nbsp;IF(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $B$3="Actuals v Plan FY26",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -SUMIFS('Netsuite IncomeStatement'!AD:AD,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Netsuite IncomeStatement'!$B:$B,$B45),0))&nbsp;Make sure spellings match exactly"Actuals v Plan FY26" must be identical to the dropdown text.Confirm correct sheet nameYou have a typo:Departmental Income Statment → missing e in "Statement"Fix the sheet name if needed.&nbsp;Hope this helps you.

Forum Discussion

multiple If and SUMIFS

1 Reply

Resources