Microsoft KB Archive/29048

Spreadsheet: Names and Addresses in Wrong Order

PSS ID Number: Q29048 Article last modified on 06-12-1996

1.x

MS-DOS

Problem: I opened a new spreadsheet, named cell c1 as’food’, and typed =sum(c2:food) in cell b3. I pressed ENTER. However, the edit line said =sum(c2:c1) instead of c1:c2.

Response: Works does not sort end points of references in expressions; this is what 1-2-3 does. However, if backward references are entered explicitly SUM(C2:C1), Works will accept them and leave them that way, just as 1-2-3 does.

KBCategory: kbother KBSubcategory: dworkskb Additional reference words:

=
================================================================ Copyright Microsoft Corporation 1996.