Adding a number to a cell that already has a number.
 

How can this be so hard? I want to keep a running attendence total. I need
to come back to a cell each day and add another number to the one that is
already in the cell. I've tried several ways that I thought were supposed to
work, to no avail. Can anyone help me?

thx.

Adding a number to a cell that already has a number.
 

See this:

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

--
Biff
Microsoft Excel MVP


"paula" wrote in message
...
How can this be so hard? I want to keep a running attendence total. I
need
to come back to a cell each day and add another number to the one that is
already in the cell. I've tried several ways that I thought were supposed
to
work, to no avail. Can anyone help me?

thx.

Adding a number to a cell that already has a number.
 

All you need to do is create a formula that you build on:

Day 1 - =sum(10)
Day 2 - =sum(10+14)
Day 3 - =sum(10+14+11)
etc.

Adding a number to a cell that already has a number.
 

In that case you don't need the SUM function.
=10
=10+14
=10+14+11
will do, without the SUM
--
David Biddulph

"HKaplan" wrote in message
...
All you need to do is create a formula that you build on:

Day 1 - =sum(10)
Day 2 - =sum(10+14)
Day 3 - =sum(10+14+11)
etc.