Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting
I am having a issue with a report. I need to update a number, once it is
updated I need 2 other cells (already with amounts in them) to add the new number and then keep there new total in their cells. basically, anytime I change one cell it adds and subtracts on others and stays there until a new add or subtraction is added. Can anyone help me? Thanks much V/r MSgt DAN ANDERS Bagram AF, Afghanistan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting
see:
http://mcgimpsey.com/excel/accumulator.html -- Gary's Student "Dan" wrote: I am having a issue with a report. I need to update a number, once it is updated I need 2 other cells (already with amounts in them) to add the new number and then keep there new total in their cells. basically, anytime I change one cell it adds and subtracts on others and stays there until a new add or subtraction is added. Can anyone help me? Thanks much V/r MSgt DAN ANDERS Bagram AF, Afghanistan |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting
Thanks sir - but I am so amatuer it did not work...I just need a cell to
update and stay (added) as I enter a value in another....' I would appreciate anyone with some step by steps... V/r MSgt ANDERS "Gary''s Student" wrote: see: http://mcgimpsey.com/excel/accumulator.html -- Gary's Student "Dan" wrote: I am having a issue with a report. I need to update a number, once it is updated I need 2 other cells (already with amounts in them) to add the new number and then keep there new total in their cells. basically, anytime I change one cell it adds and subtracts on others and stays there until a new add or subtraction is added. Can anyone help me? Thanks much V/r MSgt DAN ANDERS Bagram AF, Afghanistan |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting
"Dan" wrote: Thanks sir - but I am so amatuer it did not work...I just need a cell to update and stay (added) as I enter a value in another....' I would appreciate anyone with some step by steps... Specifically - I need the cell to add from a already determined number --NOT starting at 1? Thanks for any help.... V/r MSgt ANDERS "Gary''s Student" wrote: see: http://mcgimpsey.com/excel/accumulator.html -- Gary's Student "Dan" wrote: I am having a issue with a report. I need to update a number, once it is updated I need 2 other cells (already with amounts in them) to add the new number and then keep there new total in their cells. basically, anytime I change one cell it adds and subtracts on others and stays there until a new add or subtraction is added. Can anyone help me? Thanks much V/r MSgt DAN ANDERS Bagram AF, Afghanistan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Avoiding counting the same cell twice | Excel Worksheet Functions | |||
conditional counting with Excel | Excel Worksheet Functions | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Counting... | Excel Worksheet Functions |