Microsoft KB Archive/24622

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 18:19, 12 August 2020 by X010 (talk | contribs) (X010 moved page Microsoft KB Archive/Q24622 to Microsoft KB Archive/24622 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft 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.