| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average the last 7 numbers on a list
I have a colum of 30 numbers. I input a number in the first 7 rows. I want an
average of those 7 rows. Then when I insert a number in the next row (#8) I still want the average of the last 7 numbers continuning down to the final 7 numbers (#24 through 30) changing at every input. Im taking my blood pressure and want to know the average of the last 7 days as I input each days number. Thanks C21Man.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i get the average mean of more than 30 numbers? | Excel Discussion (Misc queries) | |||
| How can I average data from a repeating list into a unique list? | Excel Worksheet Functions | |||
| How can I average data from a repeating list into a unique list? | Excel Worksheet Functions | |||
| average of kth largest numbers in an array of n numbers | Excel Worksheet Functions | |||
| Average of numbers in column between to other numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
