Try it like this:

=A4-SUM(B4:D4)

--
Biff
Microsoft Excel MVP


"MarianneS40" wrote in message
...
This is probably something so simple, but I can't figure it out, can
someone
help?

I'm trying to deduct a range of values from the first value in the row:

A4 B4 C4 D4
200 50 60 10

The formula is in D5 and looks like this: =SUM(A4-B4:D4)

The answer SHOULD be 80, but the formula says 190.

I've also tried =SUM(A4-(B4:D4)), same issue.

I know there are ways I can work around this, but am curious why this
doesn't seem to be working?