In Excel how can I sum all the numbers above the current cell?
- by Mark Meuer
I want to have a column in Excel that consists of a header, a bunch of numbers, and then have the sum of those numbers at the bottom. I'd like the sum to adapt to the insertion of new numbers above the total. Something like this:
Numbers
1
2
5
10
18 Total
If I later insert 10 new numbers in the middle of the list, I want the sum to…