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

[paula]

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.

 

[T. Valko]

See this:

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

 

[HKaplan]

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.

 

[David Biddulph]

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