Keeping a running total of a single cell. For multiple cells.

**lpsp1994** · 05-25-2015, 07:25 AM

Hi all.

First off I'm new to the forum and excel so I do apologise if I have posted this in the wrong area.

I wanted to be able to accumulate a total for a single cell in the same cell. I don't need any trail either. So if I entered 4 into the cell and then entered 5 it would become 9 and then entered 20 it would become 29.

So far

I have used this code

Please Login or Register  to view this content.

And it works perfectly.

However on the same sheet I don't just need it to happen for A5.

I need the following cells to also do the same;

C5:C23
H5:H22
M5:M28

I want these to accumulate individually, not as columns, after each user input.

Apologies for the lack of knowledge this one really has me stumped.

Thanks in advance

lpsp1994

**lpsp1994** · 05-25-2015, 07:49 AM

Originally Posted by Fotis1991

Welcome to the forum. Pls take some minutes to read forum rules,because:

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Apologies I have now read the rules and corrected my error.

**bulina2k** · 05-25-2015, 07:54 AM

try this way:

Please Login or Register  to view this content.

**lpsp1994** · 05-25-2015, 08:26 AM

thankyou so much you are a lifesaver!

Much appreciated!

lpsp1994

Keeping a running total of a single cell. For multiple cells.

LinkBack

Thread Tools

Rate This Thread

Display

Keeping a running total of a single cell. For multiple cells.

Re: Keeping a running total of a single cell. For multiple cells.

Re: Keeping a running total of a single cell. For multiple cells.

Re: Keeping a running total of a single cell. For multiple cells.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] keeping a running total in a single cell

Keep a running total in a single cell. For multiple cells on a sheet.

Keeping a running total which set to equal two cells

Keeping and adding a running total in a single cell, not working the way I want.

Adding and keeping a running total in a single cell

Bookmarks

Bookmarks

Posting Permissions