Microsoft KB Archive/24622

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 17:53, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Multiplan: Incorrect Sum Calculation After Sorting Rows PSS ID Number: Q24622 Article last modified on 10-08-1990 PSS database name: D_MPlan

3.00 3.01 3.02 3.04 4.00 4.01 4.20

MS-DOS

Summary:

To calculate with the SUM function after sorting columns with the Sort command in a Microsoft Multiplan spreadsheet, make sure that you include the row reference for one row above and one row below the area to be sorted by the SUM function. The function will compute the sum correctly as long as the cells above and below the area are blank or contain alphabetic text.

Copyright Microsoft Corporation 1990.