Formula to always Summarize all 5 cells to the right of a column, including new columns added.
Is there any formula that can return the summary of any of the 5 columns to the right of this column layout, no matter what columns are inserted from there on?
I keep on adding columns, but I want it to always calculate the columns that are now (or in the future) within 5 columns to the right.
Help Article Resources
Check out the Formula Handbook template!