| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code not working as expected. | Excel Discussion (Misc queries) | |||
| Help !!! My code is not working as expected. | Excel Discussion (Misc queries) | |||
| Iserror not working as expected | Excel Worksheet Functions | |||
| =NETWORKDAYS not working as expected and as it once did | Excel Worksheet Functions | |||
| Lookup Not working as expected | New Users to Excel | |||
Threaded Mode
