CODEWITHSUNDEEP
excelexcel-formula
thentangler
thentangler

Reputation: 1256

Formula to Average UPTO current row in a column

I have a list of values where I want to create an expanding average with an increasing index as shown in the screenshot below. I am able to do this manually by reselecting the cells with every row. Is there a formulaic way I can do this so that I can just click and drag the formula?

enter image description here

Upvotes: 0

Views: 224

Answers (1)

thentangler
thentangler

Reputation: 1256

Just realized that I asked the dumbest question in the history of stackoverflow (for excel at least). I guess I could just pin column B2 and drag the rest. Like AVERAGE($B2$:B3) and then just drag the formula.

Upvotes: 1

Related Questions