Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
Notifications
Mark all as read
Q&A

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

+2
−0

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:

Cells Contain 3, 10, -5. Cells Display 3, 13, 8.

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.

I can use Microsoft Excel or LibreOffice Calc.

Why does this post require moderator attention?
You might want to add some details to your flag.
Why should this post be closed?

1 comment thread

Result would be ambiguous. (4 comments)

0 answers

Sign up to answer this question »

This community is part of the Codidact network. We have other communities too — take a look!

You can also join us in chat!

Want to advertise this community? Use our templates!

Like what we're doing? Support us! Donate