I have a column with numbers that is totaled at the bottom. The Auto Sum
formula correctly adds all the cells. I tried to make two of the cells
negative so that they would be subtracted. But, the cell amount is being
doubled before it is subtracted from the total. So, if the cell amount is 50,
for some reason 100 is being subtracted. I have all cells formatted as
numbers, not general or text, and have checked for hidden formulas (there are
none). Here is my example to show what is happening:
=SUM(B2:B6)
where
B2 = 5
B3 = 5
B4 = 10
B5 = 15
B6 = 15

My total is correct at 50. But if I try to make B3 -5 and B4 -10, it is
doubling each cell amount before it's subtracting, so it's subtracting 30
instead of 15. PLEASE HELP!! Thank you!!