Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,073
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
building YTD figures by adding to a previous months total axialtilt Excel Discussion (Misc queries) 7 July 24th 06 04:07 PM
Pivot Table Sub total and totals Karen53 Excel Worksheet Functions 4 July 23rd 06 07:04 PM
Old Lotus Sub Total & Grand Total formula Kylie Excel Discussion (Misc queries) 2 April 9th 06 12:24 PM
adding rows of hours and minutes to get a total Tipps Excel Worksheet Functions 1 November 4th 05 08:03 PM
Adding numbers to a running total Elizabeth Free Excel Worksheet Functions 1 August 26th 05 11:27 PM


All times are GMT +1. The time now is 08:48 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"