SUMIFS for multiple criteria

AlisonGordon ✭✭
edited 12/09/19 in Formulas and Functions

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!