| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating monthly totals
Does anyone know the best formula for adding figures in a column that
correspond to each month of the year? I have a sales register with the date of sale and commission on each row but want to display the total commissions for each month of the current year on one worksheet and monthly totals for previous year on athother worksheet. Any ideas would be greatly appreciated. Thanks Simon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Collecting weekly and monthly totals from daily data | Excel Worksheet Functions | |||
| Calculating totals | Excel Discussion (Misc queries) | |||
| How do I sum YTD totals based on monthly totals | Excel Discussion (Misc queries) | |||
| How do I forecast monthly and annual totals from previous year's . | Excel Worksheet Functions | |||
| Displaying YTD totals as you populate monthly information | Excel Worksheet Functions | |||
Threaded Mode
