We help IT Professionals succeed at work.

Dynamic Formula

Edward Pamias
on
I am pretty sure this is a simple one. I have a table which I add columns to weekly. I want the average formula to automatically update when a column is added. Currently I am using =average(b2:p2)
Comment
Watch Question

Top Expert 2015
Commented:
Epimas,

Like in previous question i have created a dynamic range for the same which i'm using in the chart series..You can use the same range to do the average and it will do what you are looking for..

what i meant to say lets say you want to do it for series1 then you can use

=average(Srs)

or for series-2

=average(Srs_2)

You can use the same ranges in your formula as well..

Saurabh...
Edward PamiasTeam Lead RRS Desk
Top Expert 2016

Author

Commented:
Thanks that worked.