All -

I am trying to figure out how to do a accumulator to an existing report that
has numbers in it already and want to update from those numbers...

example [3456] [2123] updater cell [412]
the two above change as I update the other from this point....

any help is greatly appreicated.....thanks

V/r MSgt ANDERS
OEF Afghanistan

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dan" wrote in message ...
| All -
|
| I am trying to figure out how to do a accumulator to an existing report that
| has numbers in it already and want to update from those numbers...
|
| example [3456] [2123] updater cell [412]
| the two above change as I update the other from this point....
|
| any help is greatly appreicated.....thanks
|
| V/r MSgt ANDERS
| OEF Afghanistan
|

Thanks sir - could you perhaps explain this a little, I am really new and
need some deciphering help..

Thanks

V/r MSGT ANDERS




"Niek Otten" wrote:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dan" wrote in message ...
| All -
|
| I am trying to figure out how to do a accumulator to an existing report that
| has numbers in it already and want to update from those numbers...
|
| example [3456] [2123] updater cell [412]
| the two above change as I update the other from this point....
|
| any help is greatly appreicated.....thanks
|
| V/r MSgt ANDERS
| OEF Afghanistan
|

Following the link in the right hand margin to "Getting started with macros..."

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dan" wrote in message ...
| Thanks sir - could you perhaps explain this a little, I am really new and
| need some deciphering help..
|
| Thanks
|
| V/r MSGT ANDERS
|
|
|
|
| "Niek Otten" wrote:
|
| http://www.mcgimpsey.com/excel/accumulator.html
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Dan" wrote in message ...
| | All -
| |
| | I am trying to figure out how to do a accumulator to an existing report that
| | has numbers in it already and want to update from those numbers...
| |
| | example [3456] [2123] updater cell [412]
| | the two above change as I update the other from this point....
| |
| | any help is greatly appreicated.....thanks
| |
| | V/r MSgt ANDERS
| | OEF Afghanistan
| |
|
|
|

Dan

As Niek points out...it can be done.

But what happens if you make a mistake in data entry?

You have no "paper trail" to follow to troubleshoot entries.


Gord Dibben MS Excel MVP

On Tue, 21 Nov 2006 22:46:02 -0800, Dan wrote:

All -

I am trying to figure out how to do a accumulator to an existing report that
has numbers in it already and want to update from those numbers...

example [3456] [2123] updater cell [412]
the two above change as I update the other from this point....

any help is greatly appreicated.....thanks

V/r MSgt ANDERS
OEF Afghanistan

Hi Gord,

I agree with you entirely. So does John McGimpsey, apparently; this is what he states on his site:

<I dislike accumulators on a spreadsheet, primarily because they retain no history - if an error is made, it may be impossible to
track down in an accumulator, where if the numbers were entered sequentially in a column of cells, they could be examined and
corrected

But the question keeps coming back in the newsgroups!

Since John's warning is included in the link, I just give the link.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
| Dan
|
| As Niek points out...it can be done.
|
| But what happens if you make a mistake in data entry?
|
| You have no "paper trail" to follow to troubleshoot entries.
|
|
| Gord Dibben MS Excel MVP
|
| On Tue, 21 Nov 2006 22:46:02 -0800, Dan wrote:
|
| All -
|
| I am trying to figure out how to do a accumulator to an existing report that
| has numbers in it already and want to update from those numbers...
|
| example [3456] [2123] updater cell [412]
| the two above change as I update the other from this point....
|
| any help is greatly appreicated.....thanks
|
| V/r MSgt ANDERS
| OEF Afghanistan
|

Thanks Niek

I had not been to John's site for this function for a while so had forgotten his
caveat about accumulator cells.

Gord

On Wed, 22 Nov 2006 22:37:36 +0100, "Niek Otten" wrote:

Hi Gord,

I agree with you entirely. So does John McGimpsey, apparently; this is what he states on his site:

<I dislike accumulators on a spreadsheet, primarily because they retain no history - if an error is made, it may be impossible to
track down in an accumulator, where if the numbers were entered sequentially in a column of cells, they could be examined and
corrected

But the question keeps coming back in the newsgroups!

Since John's warning is included in the link, I just give the link.

Gord Dibben MS Excel MVP

Niek and Gord - thanks but I really don't understand all the terminology - I
am just looking for the secret starter to the formula so I can start from a
different number other than 0 or 1 and keep it going.

The trail thing is an issue I agree, but the report is updated and saved
under different name each time.....thanks for all and any future help
gentlemen.

V/r MSGT DAN ANDERS

"Gord Dibben" wrote:

Dan

As Niek points out...it can be done.

But what happens if you make a mistake in data entry?

You have no "paper trail" to follow to troubleshoot entries.


Gord Dibben MS Excel MVP

On Tue, 21 Nov 2006 22:46:02 -0800, Dan wrote:

All -

I am trying to figure out how to do a accumulator to an existing report that
has numbers in it already and want to update from those numbers...

example [3456] [2123] updater cell [412]
the two above change as I update the other from this point....

any help is greatly appreicated.....thanks

V/r MSgt ANDERS
OEF Afghanistan

Dan

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


Gord

On Thu, 23 Nov 2006 20:24:01 -0800, Dan wrote:

Niek and Gord - thanks but I really don't understand all the terminology - I
am just looking for the secret starter to the formula so I can start from a
different number other than 0 or 1 and keep it going.

The trail thing is an issue I agree, but the report is updated and saved
under different name each time.....thanks for all and any future help
gentlemen.

V/r MSGT DAN ANDERS

"Gord Dibben" wrote:

Dan

As Niek points out...it can be done.

But what happens if you make a mistake in data entry?

You have no "paper trail" to follow to troubleshoot entries.


Gord Dibben MS Excel MVP

On Tue, 21 Nov 2006 22:46:02 -0800, Dan wrote:

All -

I am trying to figure out how to do a accumulator to an existing report that
has numbers in it already and want to update from those numbers...

example [3456] [2123] updater cell [412]
the two above change as I update the other from this point....

any help is greatly appreicated.....thanks

V/r MSgt ANDERS
OEF Afghanistan



Gord Dibben MS Excel MVP