Hello,

I would just like to say that so far this forum has been a wealth of information so thank you all.

I am using SUMIF to add together a range of numbers based upon whether one cell equals the same as another cell. It works, thanks to another post on this forum, but for some reason when a negative number is added into the range (for example -10) it takes off double the amount (in this case -20)

This is the formula.

=SUMIF('In-Out'!B5:B1000,"="&C5,'In-Out'!C5:C1000)

Does anyone have ideas?

I have tried for ages to get this work correctly. At first it was simply treating the negative numbers as a positive number. Until I then realized that conditional formatting does not really change the value.
On a side note does anyone know how to force a number to become a negative based upon whether one cell has the value "in" or "out" without using conditional formatting?

Any help would be appreciated.

Thank you in advance