We help IT Professionals succeed at work.

Dynamic Formula

Edward Pamias
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)
Watch Question

Top Expert 2015

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


or for series-2


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

Edward PamiasTeam Lead RRS Desk
Top Expert 2016


Thanks that worked.