Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
oneblondepilgrim
Lv 6
Is there a simple way to do a running total for a column in excel. I don't want to have to enter ?
=sum(a1,a2,a3,a4,a5,a6,a7) as I am going to have upwards of 200 items in the category. is there a shorter method to get the same result.
thanks
2 Answers
Relevance
- 1 decade ago
=sum(a1..A2000)
or if it has totals included like this...
10
10
20
5
---
45
then..
=sum(a1..a2000)/2
Still have questions? Get your answers by asking now.