Subtracting values from cells not working correctly.

Daniel Comninos

I have some countifs functions in some cells and I'm trying to subtract the value of one cell from the other. For some reason the value I'm getting when subtracting the cells is completely wrong and I'm not sure why.

Unless I'm very mistaken I think 8 -3 -4 shouldn't be equal to 5.

Daniel Comninos

I came back to it an hour or so later and it looks like the value has changed to the correct value now. But I'm still not fully sure why it wouldn't immediately change. Especially since I had refreshed the sheet previously and that hadn't fixed the problem.

Genevieve P.

Hi @Daniel Comninos

I'm glad that the formula is working for you now! I would suggest that you may want to include parentheses in your statement so it know what order to work in... for example:

= ([Total Tasks]@row - [Completed Tasks]@row) - [Overdue Tasks]@row

Or

= [Total Tasks]@row - ([Completed Tasks]@row + [Overdue Tasks]@row)

Cheers,

Genevieve