.. the average of the last 7 days as I input each days number.

Assuming source data entered in row1 down,
day numbers in col A, blood pressure readings in col B

In C7: =IF(B7="","",AVERAGE(B1:B7))
Copy C7 down as far as required.

The above will check that there's a corresponding blood pressure reading
entry made in col B before returning the average rather than the day number
in col A.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"C21man.com" wrote:
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