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

Muradbek Ibragimov2019-02-13 09:31:03

How to copy data from one table to another? 1Reply

M

Marina2022-04-05 10:45:06

How to increase the range of numbers by a certain formula? 0Reply

I

Igor Belikov2016-09-17 04:55:12

Is it possible to create a filter in the form of a drop-down list in Numbers? 1Reply

S

Sergey2019-02-19 13:38:56

How to insert substrings of a string into Excel cells? 1Reply

C

chrispsow2019-02-22 12:55:30

Removing characters up to a specific combination in a Google Sheets/Excel spreadsheet cell? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question