Use Data--Subtotals. Here's an explanation:
http://www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out: www.ExcelUserConference.com

"JerryS" wrote in message
...
I have a large spreadsheet with multiple columns and rows. I want a report
that lists totals and/or counts occurances when criteria is met in
multiple
columns. For example, column A is Rep ID, column B is Product, and column
C
is Units. I want the report to show per rep, how many of each product did
they sell. I've looked at pivot tables which are great but I want the
report
to update with formulas every time new data and rows are added. Any ideas?
--
JerryS