Here we have a sample set of data that shows t-shirt sales.
you’re able to see we have columns for date, item, color, and amount.
So let’s break this data down by color.
First, I’m going to name the Color and Amount columns in the data.
Now, in our summary table, we need a list of unique colors.
If you just have a few items in a list, there’s no need to use Remove Duplicates.
Now I’ll add the first formula.COUNTIFneeds a range and acriteria.
Since we’re counting colors, therangeis the color column.
Next, we need a criteria, and that’s where our list of colors comes in.
When I hit Enter, and copy the formula down, we have a count for each color.
Now let’s extend this summary table to include amounts.
In this case, we’ll need to use theSUMIF function.
Then we need to provide the range to sum, which is the Amounts column.
When I copy the formula down the table, we have a breakdown of amount by color.
So there you have it; we have our summary table.
And, if I change some of the source data, you’ll see the summary table update instantly.
