| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| building YTD figures by adding to a previous months total | Excel Discussion (Misc queries) | |||
| Pivot Table Sub total and totals | Excel Worksheet Functions | |||
| Old Lotus Sub Total & Grand Total formula | Excel Discussion (Misc queries) | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| Adding numbers to a running total | Excel Worksheet Functions | |||
Linear Mode
