Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use sub-totals and average in same calculation
I need to create comparison monthly worksheets.
Col A=cust Id Col B=s/person Id Col C=Prod Line Col D=Qty purchased Col E=$ sold Col F=COGS I sorted the date based on S/person, then Cust ID and sub-totaled by col D-F by cust #. I want to go on to create a second set of sub-totals by s/person or to bring the s/person Id in each sub-total line. After this is set up, I need to compare similar data for each month in the curr yr to the previous year as well as a summary report for year end. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difficult Average Calculation <HELP | Excel Worksheet Functions | |||
Calculation help from average total | Excel Worksheet Functions | |||
average calculation | Excel Discussion (Misc queries) | |||
Average Calculation | Excel Worksheet Functions | |||
Access totals, sum, average | Excel Discussion (Misc queries) |