View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MarianneS40 MarianneS40 is offline
external usenet poster
 
Posts: 2
Default Simple calc not working as expected - what am I missing?

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?