if your values are continuous with no blanks in the middle then
=AVERAGE(OFFSET(INDIRECT(ADDRESS(1,1)),MATCH(99999 99999,A:A)-30,,30))
will average last 30 values in column A and will give error if you have less
than 30 readings.







"Sick Puppy" <Sick wrote in message
...
I am making a new spreadsheet to record daily blood pressure readings.
Each
day's readings go into a row below the previous day's readings. I can use
"=average" to get the average for all entries. Is there a function or
other
means of getting the average for, for instance, the last 30 entries, which
would be for the last 30 days?

Thanks in advance!

Tim