Microsoft KB Archive/61420

Mac Works: SUM Formula Causes Error Value/Computer Hangs

PSS ID Number: Q61420 Article last modified on 10-22-1998

1.0 1.1 2.0 3.0 4.0

MACINTOSH

=
=========================================================

= SYMPTOMS =

When you enter the following formula in a Microsoft Works spreadsheet

=SUM((range)-cell)

where “range” is a range of cells to be summed (for example, A1:A10) and “cell” is either a reference on the spreadsheet (for example, C5) or a number (for example, 5), you will experience one of the following problems:

If you are using Works version 4.0 ———————————-

You will receive an error value in the cell containing the formula.

If you are using Works version 3.0 or earlier ————————————————-

Your computer may hang, and you will be forced to restart it.

= WORKAROUND =

To resolve this problem, use the following formula:

=SUM(range)-cell

= STATUS =

Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

KBCategory: kbother KBSubcategory: macworkskb

Additional reference words: 1.00 1.10 2.00 3.00 4.00 bomb mwksprb mwksss error crash stops responding ====================================================================== Version : 1.0 1.1 2.0 3.0 4.0 Platform : MACINTOSH Issue type : kbprb ============================================================================= Copyright Microsoft Corporation 1998.