SUMIFS for multiple criteria

AlisonGordon

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?

Nic Larsen

Try:

=SUMIFS(Invoiced:Invoiced, Type:Type, "Expense", Year:Year, YEAR(@cell) = 2019)

AlisonGordon

Thank you!!  Got error "INVALID DATA TYPE" 

Any other ideas?

Andrée Starå

Hi Alison,

Can you share the formula you used, describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

AlisonGordon

You are awesome.  Thank you.  Shared.  

Andrée Starå

Thanks!

Happy to help!

I'll take a look and get back to you!

Paul Newcome

You were actually very close in your posted formula. You should be able to just add quotes around Expense.

 

=SUMIFS(Invoiced:Invoiced, Type:Type, "Expense", Year:Year, 2019)

Andrée Starå

Glad we got it working!

Have a fantastic day!

Best,

Andrée