SUMIF/ DSUM

Hello Brian,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding using either SUMIF / DSUM.

I put together a few numbers similar to what you described in your question. I used a criteria area which has drop down lists which make it easier to produce the data you require.

I have also added an auto filter which you can use to provide the same results. At the bottom of the total column I added a subtotal function which helps when working with autofilters.

Test what I have given you and then try it out on your data sheet.

I have attached the file for your use.

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. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer