Sum Function in Excel 2000

I have a simple spreedsheet. The very last column contains a formula. I have that cell formated to display a whole number (no decmial). At the bottom of this column I want to sum the numbers in the column. When I attempt to do this execl is taking the absolute value of the number and adding. What I want to do is to add the whole numbers (after rounding)

Data: Cell J5 contains the formula 6*530/2000
Cell J6 contains the formula 100*556/2000

Absolute value of J5 is 1.59 cell is formated to display 2
Absolute value of J6 is 27.8 cell is formated to display 28

Absolute value of J32 is 29.39. I want excel to sum the displayed values not the absolute value.