Gate: All you need to do is learn the Subtotals feature. See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"GateKeeper" wrote in message
...
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