Can a cell contain a number, but display a cumulative sum?

Is there a way to just type a number into a cell, but have the cell display the running total of the numbers in the column? Here is an example of what I want to type versus what I want to see:

I know this can easily be done using pairs of columns, with the raw numbers in "helper" columns, and the SUM formula in the main columns (like in my example image), but I don't want to use so many extra columns.

needs author's attention

This question is off-topic or cannot be reasonably answered in its current form and needs revision by its author.

This flag will be added as a comment to this post's feedback thread.

is a duplicate

This question has been asked before and has already been answered. It should be marked as a duplicate.

Please enter the URL of the proposed duplicate in the details field below.

not constructive

This question cannot be answered in a way that is helpful to anyone. It's not possible to learn something from possible answers, except for the solution for the specific problem of the asker.

Communities

Can a cell contain a number, but display a cumulative sum?

1 comment thread

0 answers