ExcelBanter - KEEPING THE TOTAL IN C3 WHEN ADDING B3

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - KEEPING THE TOTAL IN C3 WHEN ADDING B3 (https://www.excelbanter.com/excel-discussion-misc-queries/105790-keeping-total-c3-when-adding-b3.html)

bouncer8

KEEPING THE TOTAL IN C3 WHEN ADDING B3

I want cell C3 to keep the total even when i change cell B3, for example say
the total in C3 is 10 then i want to keep changing B3 but to keep adding onto
C3. So C3 is 10 then i change B3 to 6 so C3 should read 16 then i want to
change B3 again to 3 so the total in C3 should go to 19.
Anybody any ideas?

Ken Johnson

KEEPING THE TOTAL IN C3 WHEN ADDING B3

Hi Bouncer,

1. Go Tools|Option|Calculation tab...tick "Iterations", then make
"Maximum iterations" = 1
2. in C3 add the formula =B3 + C3

Ken Johnson

All times are GMT +1. The time now is 06:43 AM.