Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Add money to a sum
Hi
We are a bunch of horsebetting people that has made a calc in Excel to keep track of how much we pay each week. I have a little problem that I want to solve. I want to for example have the sum of all that we paid in A1 and be able to add money to that sum, not by adding by hand, just getting it from another cell. Do you know the best way to do that? Kjell Olsson Sweden PS. Excuse me for my bad English |
#2
|
|||
|
|||
In A1:
=SUM(range of cells you want to add) -- Regards, Dave "Tjoken" wrote: Hi We are a bunch of horsebetting people that has made a calc in Excel to keep track of how much we pay each week. I have a little problem that I want to solve. I want to for example have the sum of all that we paid in A1 and be able to add money to that sum, not by adding by hand, just getting it from another cell. Do you know the best way to do that? Kjell Olsson Sweden PS. Excuse me for my bad English |
#3
|
|||
|
|||
Kjell
Sounds like you want an "accumlator" cell. 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 Having said that, check out J.E. McGimpsey's site for VBA methods. http://mcgimpsey.com/excel/accumulator.html Gord Dibben Excel MVP On Tue, 6 Sep 2005 17:06:11 -0700, Tjoken wrote: Hi We are a bunch of horsebetting people that has made a calc in Excel to keep track of how much we pay each week. I have a little problem that I want to solve. I want to for example have the sum of all that we paid in A1 and be able to add money to that sum, not by adding by hand, just getting it from another cell. Do you know the best way to do that? Kjell Olsson Sweden PS. Excuse me for my bad English |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
export to microsoft money | Excel Discussion (Misc queries) | |||
problem with msn money stock quote add in | Excel Worksheet Functions | |||
How can I upload a spreadsheet to MS Money Deluxe (or convert)?? | Excel Discussion (Misc queries) | |||
Money for life | Excel Worksheet Functions | |||
Money for life | Excel Discussion (Misc queries) |