| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding the same number to each cell in a column | New Users to Excel | |||
| Adding number to each cell in a column | Excel Discussion (Misc queries) | |||
| Adding number to a cell reference not to the contents | Excel Worksheet Functions | |||
| adding number in next cell | New Users to Excel | |||
| adding number only if CDN is displayed in next cell | New Users to Excel | |||
Linear Mode
