software

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

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

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