Are there any ".Range" commands above the =SUM()? These may be adding rows.

Use the SUM button on the toolbar to explicitly add the cell together you want. Make sure the sheet is collapsed when entering the formula.