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

  • Thread starter Thread starter 65Stang
  • Start date Start date
6

65Stang

What's the best way to average a range of cells that grows on
weekly-basis without modifying the formula weekly
 
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)
 
You must log in or register to reply here.

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

average range growing 2
setting a range automatically 5
Average of absolute values of moving ranges 1
average if question 2
Averaging weekly data into Months 1
Average Goal Calculation 4
AVERAGE cells on another worksheet when the range is calculated 1
Averaging 1

Back
Top