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
|