Lets say I have a formula in A1 which adds A2+B2...

In C1 I want a formula to 'count' how many times A1 equals a negative number... i.e. IF A1 = <=-1, +1

I hope this makes sence, please let me know if you'd like futher explanation.

Ben