| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Keeping a running tab at bottom of column.
I created a table that has columns to which I add values periodically. At
the bottom of each column, I created formulas for adding the above cells together. For example: =SUM(C2:C49), where the sum is displayed in cell C50. When I add new data to the column, I click in cell C50 and press F9 to revise the total. The problem is the old total gets added to the new total, so that all previous cells are added twice, making the F9 function useless. If I delete the number in cell C50, the formula gets deleted as well. Is there a different way I need to write the formula in order that only the new values will be added to the previous total? |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| bottom of the screen page, column, line frame is missing | Microsoft Word Help | |||
| Distance bottom edge of the page to bottom edge footer - not accep | Page Layout | |||
| formatted paragraph shading top of 2nd column appears bottom 1st c | Microsoft Word Help | |||
| Keeping text together on column or page in merged directory. | Mailmerge | |||
| Dragging table column resets | Tables | |||
Threaded Mode