What if there aren't 30 values to average?

Are there any empty cells within the range?

--
Biff
Microsoft Excel MVP


"~slacker~" wrote in message
...
I'm trying to average the last 30 values in a column.
Column A contains a date and Column B contains a value for that date.
A running average of the last 30 days (or 1-month) needs to be kept so
that if new data is entered the average automatically updates.

any ideas?

I was thinking something like
=AVERAGEIFS(B:B,A:A,LARGE(A:A,30))

but the greater than seems to muck things yup.

thanks