Good Morning. I've been struggling with this multiple sumif statement and I don't know if it is because I have too much criteria.
In the attached spreadsheet I have a sample budget. The budget has 3 named tables. In the 3rd table I'm trying to sum the amounts per 'program' by per 'period'.
=SUMIF(MyTransactions1[Program Code],"=" &[@[Program Code]],MyTransactions1[Expense Actual/Enc]) - this is the formula I've been using to sum the amounts per program. Now I just want to add to this statement and in another column sum by 'Period' as well.
I keep trying different options:
=SUMIF(MyTransactions1[Program Code],"=",MyTransactions1[Cleared Actual],"Period 01" &[@[Program Code]],MyTransactions1[Expense Actual/Enc])
"Period 01 - Period 12" is my variable range and will change.
But I just can't figure out the correct way to write this statement. Everything I keep looking at doesn't help the formula. I keep getting told I have 'too many arguments'.
Is there a better way I could do this?
budget ss.xlsx
Bookmarks