ExcelExplained

Subtotal by item type using SUMIF

If you need to subtotal numbers by type, you can easily do so using the SUMIF function. You can also look at this article if you need to sum items by date.

How to sum orders by item type

Sum orders by item type

Our workbook contains the same data from our previous COUNTIF example, where we wanted to know how many orders were placed that contained a certain item. In this worksheet, cell C2 contains the following formula:
=SUMIF(orders,item,amount)
or
=SUMIF(B9:B19,B2,C9:C19)

The SUMIF function uses three arguments: range, criteria, and sum_range. In our example these arguments are:
range: B9:B19, also named orders – this is the set of cells where SUMIF will apply the criteria
criteria: B2, also named item – this is the value SUMIF will try to find in the range
sum_range: C9:C19, also named amount – the set of cells that will be summed by SUMIF when the provided criteria is TRUE

You can download the Excel workbook if you want to take a closer look at the formula.

If you have additional questions please let me know by posting a comment.

Add comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Beautiful Excel line chart

Improve your Excel skills

Learn how to work with functions, create complex formulas and design beautiful charts. All free.

You have Successfully Subscribed!