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
Bookmarks