| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complicated Table Functions
I am creating a summary sheet for a complaint log. I would like the summary
data to change based on the month and year that is typed in the cell on the summary tab. Below is the summary page data. I need help creating the formulas for everything below the dashed line. I can easily and quickly provide any additional data that might be helpful. See below for locations of the data on the Data sheet: Dollars Associated- Q7:Q9999 Reason Category- K7:K9999 Responsible Party- L7:L9999 Summary For Month 2008 1 Total Sales Dollars $- Total Credit Dollars $14,099.53 Credits as % of Sales #DIV/0! ------------------------------------------------------------ Total Instances 0 Reason Category Simple Count Dollars Associated Non Sales Admin Pricing Non Sales Admin Freight Non Sales Admin Other Sales Admin Pricing Sales Admin Freight Sales Admin Other Count By Coordinator (If Responsible) Simple Count Dollars Associated Allie Alma Anne Billie Georgeann Jennifer Joan Karen Lorena Tom Other (Non Coord) Reason by Rep Pricing Freight Other Allie Alma Anne Billie Georgeann Jennifer Joan Karen Lorena Tom |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Complicated Table Functions
I forgot to add that I need (would like) the table to change when the month
and date entry is changed "Jeremy" wrote: I am creating a summary sheet for a complaint log. I would like the summary data to change based on the month and year that is typed in the cell on the summary tab. Below is the summary page data. I need help creating the formulas for everything below the dashed line. I can easily and quickly provide any additional data that might be helpful. See below for locations of the data on the Data sheet: Dollars Associated- Q7:Q9999 Reason Category- K7:K9999 Responsible Party- L7:L9999 Summary For Month 2008 1 Total Sales Dollars $- Total Credit Dollars $14,099.53 Credits as % of Sales #DIV/0! ------------------------------------------------------------ Total Instances 0 Reason Category Simple Count Dollars Associated Non Sales Admin Pricing Non Sales Admin Freight Non Sales Admin Other Sales Admin Pricing Sales Admin Freight Sales Admin Other Count By Coordinator (If Responsible) Simple Count Dollars Associated Allie Alma Anne Billie Georgeann Jennifer Joan Karen Lorena Tom Other (Non Coord) Reason by Rep Pricing Freight Other Allie Alma Anne Billie Georgeann Jennifer Joan Karen Lorena Tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Functions in a pivot table | Excel Discussion (Misc queries) | |||
| rather complicated table to consolidate | Excel Discussion (Misc queries) | |||
| complicated calculation in my pivot table | Excel Worksheet Functions | |||
| How do you create a complicated pivot table graph? | Charts and Charting in Excel | |||
| pivot table, functions for subtotals | Excel Worksheet Functions | |||
Linear Mode
