How to use SUMIFS with a table

Tip: How to use SUMIFS with a table

In this video, we’ll look at how to use the SUMIFS function with an Excel table.

On this worksheet, I have two identical sets of order data. I’m going to walk through the process of constructing a summary of sales by item for both sets of data.

With the data on the left, I’ll use standard formulas and no table.

On the right, I’ll create an Excel Table, and build formulas that use structured references.

To start off, I’ll add a bit of formatting to the data on the left to make it easier to see.

Now I’ll use the SUMIFS function to sum sales by item.

Duration 
3:40
Author 

Leave a Reply

Your email address will not be published. Required fields are marked *