Forum Discussion
How can you dynamically change an Excel table column reference?
I have multiple Excel tables storing numeric values. I am summarizing a rows values like this: =+SUM(Query_Current_Year[@[Begin_Balance]:[Balance_Period6]]) Every month, I need to update each t...
As variant you may use formula like this
it sums all columns except last one, no changes are required if another column is added/removed