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