Answer the question
In order to leave comments, you need to log in
How to count the sum of cells from start to adjacent cell in Excel?
Hello.
I have some column of real numbers in Excel (for example from A1 to A100).
I need to create a second column (for example, from B1 to B100) whose cells would have the following values:
Cell B1: =SUM(A1:A1)
Cell B2: =SUM(A1:A2)
Cell B3: =SUM(A1: A3)
Cell B4: =SUM(A1:A4)
Cell B5: =SUM(A1:A5)
Cell B6: =SUM(A1:A6)
Cell B7: =SUM(A1:A7)
Cell B8: =SUM(A1: A8)
.....
Cell B99: =SUM(A1:A99)
Cell B100: =SUM(A1:A100)
How can I calculate such a column (from B1 to B100) in Excel?
PS I actually have more cells and it takes a long time to do it manually.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question