Formulas

Hello Stacey,
I hope you enjoyed your Excel training sessions with us.

In response to your question, SUMIF does not support multiple criteria. However, for a fairly straightforward example as you have given, you may try DSUM instead. The DSUM formula is as follows:

DSUM(database,field,criteria)

The database is the entire range of cells that you are referencing in your formula. The field indicates which column you are summing. Criteria is the range of cells that contains the conditions that you specify. You need to create the criteria ahead of time, in much the same way as you would for an advanced filter.

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer