A
A
Alexey Smirnov2016-05-09 22:08:07
excel
Alexey Smirnov, 2016-05-09 22:08:07

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

1 answer(s)
A
Alexey, 2016-05-09
@ERAFY

=СУММ($A$1:A1)
And multiply the formula "down".

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question