| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
7 previous days average
Glad to hear that Carlee!
Regards Martin "Carlee" wrote in message ... it worked !! It worked!! It worked!!! Thank you so very much for all of your help. -- Carlee "MartinW" wrote: Hi Carlee, Unless I'm missing something here (quite probable!) All you need to do is put this in AK9 =IF(AJ9="","",AVERAGE(AJ3:AJ9)) and drag it down as far as your future needs require. The references update as you drag to give you a rolling 7 cell average. HTH Martin "Carlee" wrote in message ... Hi All, Question: What function can i use to create an average value of the previous 7 days? Column AJ contains data, which is added to everyday Column B contains the date In Column AK, I want to have a value, which calculates the average value, of the 7 previous values entered in column AJ. Data starts in row 3 for all columns. -- Carlee |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average of previous values | Excel Discussion (Misc queries) | |||
| Average based on the previous row | Excel Worksheet Functions | |||
| Subtract # of days from date, but if not sat, goto previous sat? | Excel Discussion (Misc queries) | |||
| 25 days previous to today? | Excel Discussion (Misc queries) | |||
| date functions for previous 60/90/180 days | Excel Worksheet Functions | |||
Threaded Mode
