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.

In article ,
"whiteteeth" wrote:

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!