Instead of using the sum function to add a column, just place the cursor in the cell where the total would go (bottom cell) and press alt + + (plus sign) it will add the cells in that column