The good news is you can build your own summaries using functions like COUNTIF and SUMIF.

This isnt necessary, but naming these ranges means I wont need to use absolute addresses later, and itll make the formulas really short and easy to read.

To build this list, Ill copy the full list, then use the remove duplicates command in Excel.

But its a great way to build a clean list of unique values when youre working with unfamiliar data.

We already have the colors in a list in our table, so I can just point to that column and pick up the reference.

When I hit enter, and copy the formula down, and we get a count for each color.

As before, I need provide color as the range, then pick up the name of the color as a cell reference in our table.

COUNTIF can be used to count cells that contain dates, numbers, and text.

The SUMIF function supports logical operators (,,) and wildcards (,) for partial matching.

SUMIFS can be used to sum values when adjacent cells meet criteria based on dates, numbers, and text.

We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

I now need to work these arrays into my complicated spreadsheets -Jeremy.

Excel For Mac Adding Summary Statistics