Fixed running total

Hi
I know how to total sum cells together but-
I need for example, if AA5,AA6,AA7,AA8= 1 (AA5 has 1 in it) and i change the value in AA5 back to 0 the sum total stay fixed at 1, so if AA6 was to show 3 it would =4 and keep an ongoing total regardless of numbers changing back to 0 in above cells, make sense?


Moderator's note: Cross-posted at https://www.mrexcel.com/forum/excel-...ing-total.html

Welcome to the Forum bizmark222!

I'm getting the general idea but there are some details you need to explain to us.

First, it sounds like you want to enter some numbers into some cells. Then if you change any of the numbers you want the other numbers to be automatically adjusted to keep the sum the same.

How do you determine what you want the fixed sum to be?

If you change AA5, there are three other cells--which ones do you want to change to keep the sum fixed?

Regardless of the details, if cells have numbers in them (not formulas), and you want those numbers to change automatically, then a macro is required.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Read this to understand why we (and other sites like us) consider this to be important.

I have provided the link because you are a new member.

I think it would require VBA (some programming) as the cells do not have memories and would not be able to keep track of what values you had in them before.

What would you expect if you changed AA5 multiple times? Would it sum up the total of all these changes?

The coding is not difficult but, as StringJazzer said, a little more information would help. How many cells are we talking about? An example workbook would also help.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

You can use VBA or you can use iteration. Here's how to do it with iteration
1. Go to File>Options>Formulas > Calculation options. Check "Enable iteration calculation"

2. Then in your worksheet, (let's say your 0's and 1's are going in column B and your values are in column A)
Enter this formula in B2 copied down

Formula:

Please Login or Register  to view this content.

See example workbook. Does that do what you asked?