Hi MarianneS40

the formula should be :
=A4-sum(B4:D4)

click yes below, if it helps

"MarianneS40" wrote:

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?