| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
KEEPING THE TOTAL IN C3 WHEN ADDING B3
Hey try this ... Type =B3+C3 in cell C3. Then go to Tools Options Calculation and select automatic or manual calculation as you want. Then select *Iteration* and for Maximum Iterations, type in 1. This should solve your problem. bouncer8 Wrote: 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? -- workerboy ------------------------------------------------------------------------ workerboy's Profile: http://www.excelforum.com/member.php...o&userid=34121 View this thread: http://www.excelforum.com/showthread...hreadid=573051 |
| 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 | |||
Hybrid Mode
