Forum Discussion
multiple If and SUMIFS
Good evening, Need help with following multiple criteria. Trying to select Department or all expenses through drop down menu. Thank you No problem with one criteria (first statement of selecting Ma...
You want:
- If B3 = "Marketing", run a SUMIFS with Department = Marketing
- If B3 = "Actuals v Plan FY26", run a different SUMIFS
- Otherwise return 0
=IF(
$B$3="Marketing",
-SUMIFS('Netsuite IncomeStatement'!AD:AD,
'Netsuite IncomeStatement'!$E:$E,$B$3,
'Netsuite IncomeStatement'!$B:$B,$B45),
IF(
$B$3="Actuals v Plan FY26",
-SUMIFS('Netsuite IncomeStatement'!AD:AD,
'Netsuite IncomeStatement'!$B:$B,$B45),0))
Make sure spellings match exactly
"Actuals v Plan FY26" must be identical to the dropdown text.
Confirm correct sheet name
You have a typo:
Departmental Income Statment → missing e in "Statement"
Fix the sheet name if needed.
Hope this helps you.