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.
....

=-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.