SUMIFS for multiple criteria
This should be fairly simple, but I am spinning on this syntax. Trying to sum my "Invoiced" column if the Year Column = "2019" and the Type Column = "Expense". I have tried a few variations, but this is what I think should work?
=SUMIFS(Invoiced:Invoiced, Type:Type, Expense, Year:Year, 2019).
I have tried quotations around the criteria, I have tried square brackets around the ranges).... Help?
Help Article Resources
Check out the Formula Handbook template!