Spreadsheet Summary Report

[Guest]

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?

 

[Anne Troy]

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