I will try that. Thanks for your help.

"Spiky" wrote:

On Sep 18, 1:44 pm, tulip wrote:
Spiky - can you help me with the suggestions you made? I don't know how to
use the ROW or OFFSET to capture the new A34. =AVERAGE(INDIRECT("A1:A"


Well, if the formula is directly below the list it is averaging, like
in A34 in your original example:
=AVERAGE(INDIRECT("A1:A"&ROW()-1))

It matters where you enter this formula. My example calculates from
where it is, less one row. That keeps it dynamic so you can insert
either at the top or bottom of the list.