Microsoft KB Archive/44773

Works: Subtracting a List of Numbers

PSS ID Number: Q44773 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 =

Although there is no function to subtract a list of numbers from the first number in a list, you can create a formula that references the first number, which is followed by a minus sign, then the sum of the other numbers in the list.

Example
To subtract cells A2 through A6 from the value in cell A1, the formula would appear as follows:

=A1-SUM(A2:A6)

KBCategory: kbother KBSubcategory: dworkskb:

= Additional reference words: =

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