Add a total column to tables
Currently, there is a total row that sums all of the numbers in the same column. It would be nice to have this same thing but transposed, where excel automatically adds a total column that adds everything in that respective row. I am making a manual inventory right now, and every time there is a new order I have to update the SUM function to include the new quantities.
2
votes
Nick Bell
shared this idea
1 comment
-
Sergei Baklan
commented
Nick, didn't catch, do you mean something like =SUM(Table1[[#Totals],[A]:[Z]]) ?