Microsoft KB Archive/62883

Works: Cumulative Totals in Works Spreadsheet

PSS ID Number: Q62883 Article last modified on 10-16-1998

1.00 1.05 2.00 3.00

MS-DOS

=
========================================================= 1.00 1.05 2.00 3.00 MS-DOS kbother

= SUMMARY =

You can maintain a cumulative total in a Works spreadsheet using only two cells. The idea is similar to that of an adding machine, which maintains an accumulator that totals all of the numbers that have been entered. The example in the next section shows you how to make a cell use its own current value to create a cumulative total.

Example
The example is created by entering the following formula in cell B5 of a Works spreadsheet:

=B5+A5

Cell B5 is the cell containing the cumulative total. Each new entry is sequentially entered into cell A5. The last entry made in cell A5 must be zero in order to maintain its current balance. Numbers can be repetitively entered into cell A5 and a cumulative total will build in cell B5.

= MORE INFORMATION =

A problem with this technique is that each time a change is made to any part of the spreadsheet under default conditions, the last entry in cell A5 will be added to the contents of B5.

A change in the cumulative total can be avoided by making sure that the last entry made in A5 is always a 0 (zero). Recalculation is controlled from the Options menu with the Manual Calculation and Calculate Now options.

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: 1.00 1.05 2.00 3.00 =

Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.