How to build a simple summary table

Tip: How to build a simple summary table

In this video, I want to show you how to build a quick summary table using the COUNTIF and SUMIF functions.

Here we have a sample set of data that shows t-shirt sales.

You can see we have columns for date, item, color, and amount.

So, let’s break down this data by color.

Now, before we start, I want to mention that pivot tables would be an excellent way to summarize this data, but you can certainly use formulas for basic summaries, and that’s what I’m going to demonstrate here.


Related shortcuts

Leave a Reply

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