| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spreadsheet Summary Report
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Spreadsheet Summary Report
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| How do I create a push report in Excel? | Excel Discussion (Misc queries) | |||
| Linking worksheets after runnning report | Excel Discussion (Misc queries) | |||
| Microsoft Access Report into Excel Spreadsheet | Excel Discussion (Misc queries) | |||
| Creating a summary from existing spreadsheet data ... | Excel Worksheet Functions | |||
Linear Mode
