Sum of column when moving rows
When I move rows to a destination sheet, I need to have a running sum of one particular column as each row is added.
I've tried doing a sum of children (but the moved row comes in at the wrong position) or just an auto sum at the top of the sheet but when new rows are added, they don't get summed.
Is there an easy way to accomplish this?
Best Answer

=SUM([Column 2]:[Column 2])
This will only work if you put the formula in a different column. In my example, the formula is in Column 1 and adding up all the values in Column 2
Alternately, you could put the same formula in the sheet summary and you wouldn't have to add the new column.
Answers

=SUM([Column 2]:[Column 2])
This will only work if you put the formula in a different column. In my example, the formula is in Column 1 and adding up all the values in Column 2
Alternately, you could put the same formula in the sheet summary and you wouldn't have to add the new column.

Thank you!
Help Article Resources
Categories
Check out the Formula Handbook template!