| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you use microsoft excel to calculate year to date average
i am setting up a spreadsheet for work and want to be able to enter monthly
statistics and have a year to date percentage calculation. i want to be able to sit with employees each month a say this is your sales figures for Jan, Feb ... and so far this is your year to date sales average. Each time I get new monthly statistics and enter into the spreadsheet I want the year to date average to change. Hope this is clear enough to understand what my objective is thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do you use microsoft excel to calculate year to date average
On 12 Jun, 21:41, deana wrote:
i am setting up a spreadsheet for work and want to be able to enter monthly statistics and have a year to date percentage calculation. i want to be able to sit with employees each month a say this is your sales figures for Jan, Feb ... and so far this is your year to date sales average. Each time I get new monthly statistics and enter into the spreadsheet I want the year to date average to change. Hope this is clear enough to understand what my objective is thanks Sub haydn() icolumn = 1 irow = ActiveSheet.UsedRange.Rows.Count Cells(irow + 1, icolumn).Formula = "=Average(" & ((Chr(icolumn + 64)) & "1:" & (Chr(icolumn + 64)) & irow & ")") End Sub Peter |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Averaging cells in separate workbooks to make year-to-date average | Excel Discussion (Misc queries) | |||
| Calculate Average for same period last year | Excel Discussion (Misc queries) | |||
| calculate year-to-date total | Excel Worksheet Functions | |||
| Calculate a date based on period and year | Excel Worksheet Functions | |||
| Microsoft Excel : How can we get the date of the Monday of Week 44 of Year 2005? | Excel Worksheet Functions | |||
Hybrid Mode
