Link to home
Create AccountLog in
Avatar of Edward Pamias
Edward PamiasFlag for United States of America

asked on

Dynamic Formula

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)
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Edward Pamias

ASKER

Thanks that worked.