Average the last 7 numbers on a list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
.. 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Averaging values from a list, based on user input 3
Last Number to Average 3
Averages with conditions.... 1
average of non-contiguous range based on criteria 3
7 Day Pacing Formula Help 2
Last 7 days 9
I have a column of 120 numbers 2
average sum of 5rows 3

Back
Top