Function expects # values

[RippingMyHairOut]

People eve of crap doesn't think $11 is a number value!!! Look at the screen shot. All the others are fine and this one is setup the same way. Not when I hange the number does it **** up. I imported it into sheets and not editing the numbers the values don't work damn it.

[TMS]

In your picture, it is displayed as left aligned. Unless you have formatted like that, it's not a number, it's just text that looks like a number.

Try editing the value and removing the dollar sign. Then format the cell as currency.

And you don't need SUM in =SUM(E10-E3-E11). =E10-E3-E11 will do the same thing (and might work with the Text value)


Regards, TMS