SUMIFS for multiple criteria

AlisonGordon · 08/19/19

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 · 08/19/19

Try:

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

AlisonGordon · 08/20/19

Thank you!! Got error "INVALID DATA TYPE"

Any other ideas?

Andrée Starå · 08/20/19

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 · 08/20/19

You are awesome. Thank you. Shared.

Andrée Starå · 08/21/19

Thanks!

Happy to help!

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

Paul Newcome · 08/21/19

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å · 08/21/19

Glad we got it working!

Have a fantastic day!

Best,

Andrée

SUMIFS for multiple criteria

Comments

Help Article Resources

Categories