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?

Find more posts tagged with

Manufacturing

Sheets

Formulas

Reports

Project Management

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

SUMIF function not working
=SUMIFS({GM Compliance Trained}, {GM Compliance Training Dept}, Department@row , {Compliance Training Date}, MONTH(7, 8, 9)) GM Compliance Trained is the number of employees trained. I am trying to sum the number of employees trained in each department during 3rd quarter (July 1-Sep 30). Thinking I need an IFERROR in there…
Prevent due dates from falling within the same calendar week?
Hi. I am working on a (roughly) annual document review system, in partnership with another team in my organization. They have requested that they receive one document to review per week. But there are more documents to review than there are weeks in the year. So I need to figure out a method for ensuring that I don't send…
How to record date without time
I would like to use automation on a sheet to record the Open and Closed date for a given RAID item. I don't want to record the time, however. Is there a way to exclude a time stamp from the automation? If it is not possible to exclude the time stamp, what formula would I need to use to extract the datae and time into…