Remember Me?

#1
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 3
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
 external usenet poster Posts: 1
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
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

#3
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 22,906
KEEPING THE TOTAL IN C3 WHEN ADDING B3

Are you sure you want to do this?

Think about it after reading the following.

You can have a cumulative total in a cell if you have a
separate source cell for adding a new total to the original.

Use at your own risk. I am Posting this just to show you how it can
be done, not as a good solution. You would be much better off to
have another column so you can keep track of past entries.

Goes like this: =IF(CELL("address")="\$C\$4",C4+D4,D4)

Enter this in cell D4 and then in ToolsOptionsCalculation check
Iterations and set to 1.

Now when you change the number in C4, D4 will accumulate.

Note 1. If C4 is selected and a calculation takes place anywhere in
the Application D4 will update even if no new number is entered in
C4. NOT GOOD.
Note 2. This operation is not recommended because you will have no
"paper trail" to follow. Any mistake in entering a new number in C4
cannot be corrected. NOT GOOD.

To clear out the accumulated total in D4 and start over, select D4
and EditEnter.

Check out Laurent Longre's MoreFunc.xla. Has a Function RECALL
which does what you want without the re-calculation problem, but
again there is no "paper trail" for back-checking in case of errors
in data input.

http://longre.free.fr/english/func_cats.htm

Also see John McGimpsey's site for VBA method.

http://www.mcgimpsey.com/excel/accumulator.html

Gord Dibben Excel MVP

On Fri, 18 Aug 2006 06:27:02 -0700, 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?

Gord Dibben MS Excel MVP
#4
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 1,073
KEEPING THE TOTAL IN C3 WHEN ADDING B3

Hi Gord,

Thanks for that information.
I knew there had to be something bad about that technique.
Fools rush in etc:-)

Ken Johnson

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post axialtilt Excel Discussion (Misc queries) 7 July 24th 06 04:07 PM Karen53 Excel Worksheet Functions 4 July 23rd 06 07:04 PM Kylie Excel Discussion (Misc queries) 2 April 9th 06 12:24 PM Tipps Excel Worksheet Functions 1 November 4th 05 08:03 PM Elizabeth Free Excel Worksheet Functions 1 August 26th 05 11:27 PM

All times are GMT +1. The time now is 09:50 AM.