How to calculate the sum of a column up to a certain value in Excel?

R

R

Rad1us2015-06-21 16:47:34

excel

Rad1us, 2015-06-21 16:47:34

How to calculate the sum of a column up to a certain value in Excel?

Column A is the date.
Column B - values.
It is necessary that the cells of column C display the sum of the cells of column B, going in order to the cell of column C. (for example, in C9 - the sum of all B to B9, in C20 - the sum of all B to B20, etc.) What formula / method it can be done?
screenshot, if anything, I post it:

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

Similar questions

M

mr jeery2017-10-09 15:58:06

How to convert cell value to specific format in EXCEL? 1Reply

C

CheesR2017-10-10 10:26:37

There is a large database of addresses in Excel, in a format like: "Far street" must be converted to the format "Far street." Are there any functions for this? 1Reply

K

Kostya122017-10-12 09:19:56

How to implement a loop in Excel? 1Reply

V

vbif2017-10-12 13:04:16

How to get data from excel file without using OPENROWSET? 0Reply

S

Sergey Dydaevskiy2017-10-18 12:01:52

Excel - how to extract content between the last two "/" from a relative link? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question