I have a spreadsheet with 11 columns and 333 records. I need to create a
summary based on the data in one of the columns.

The data looks like this:
Item, Brand, Form, Formula, Size, Units
I need to summarize the data by "Form", like this:

form1: count(brands); count(forms); count(formulas)
form2: count(brands); count(forms); count(formulas)

So for each Form, I need the number of brands that have that form, etc.

What can I do?

GateKeeper
Experienced Computer User