View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
C21man.com C21man.com is offline
external usenet poster
 
Posts: 1
Default 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