I need a formula for cumulative sum. Consider:
+--+---+
| 1| 1|
+--+---+
| 1| 2|
+--+---+
| 2| 4|
+--+---+
| 3| 7|
+--+---+
| 4| 11|
+--+---+
| 5| 16|
+--+---+
| 6| 22|
+--+---+
| 7| 29|
+--+---+
| 8| 37|
+--+---+
| 9| 46|
+--+---+
|10| 56|
+--+---+
|11| 67|
+--+---+
|12| 79|
+--+---+
|13| 92|
+--+---+
|14|106|
+--+---+
The formula for B1 would be =(A1).
For B2 => =(A1+B1).
For B3 => =(A1+B1+C1).
Etc.
Programming each Cell in Column B could get tedious.
Is there a better way?
Thanks
b1 = sum($a$1:$a1)
and drag down
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Great. Thanks, but there is a problem. My fault.Originally Posted by oeldere
I forgot to mention that there are two rows of test column titles etc. at the top of the table.
This formula gives a result like:
+--+---+
| 1| 0|
+--+---+
| 1| 0|
+--+---+
| 2| 1|
+--+---+
| 3| 2|
+--+---+
...
How do I fix that?
Thanks again
Computers only give answers.
b3 = sum($a$3:$a3)
and drag down.
Thanks for the rep.
For the future, please also reply in the topic.
Glad I could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks