how can I subtract the contents of several cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know that by entering SUM=(b1:d1) in the formula bar, this will add the
contents of these cells. How can I do this with subtraction without entering
=(b1-c1-d1)? Thanks!
 
One way:

=B1-SUM(C1:D1)

Alternatively, you could array-enter (CTRL-SHIFT-ENTER or CMD-RETURN):

=SUM(B1,-C1:D1)

Note that the second solution won't ignore text.
 
JE McGimpsey wrote...
....
Alternatively, you could array-enter (CTRL-SHIFT-ENTER or CMD-RETURN):

=SUM(B1,-C1:D1)

Note that the second solution won't ignore text.
Click to expand...
....

=-SUM(-B1,C1:D1)

will avoid the need for array entry and will only fail to ignore text
in B1. This is an old (REAL OLD) 123 trick.
 
Back
Top