How do you average a range of cells that continually grows?

6

65Stang

What's the best way to average a range of cells that grows on
weekly-basis without modifying the formula weekly
 
D

Don Guillett

I would make a defined name range
insert>name>define>name it mygrowingrange>in the refers to box use offset
=offset($A$2,0,0,counta($a:$a),4)
so now this range will automatically grow with each item in col a
=average(mygrowingrange)
 
Top