My lazy fix is to just create a new column, making sure the first cell has no text in it to prevent all cells being cloned to this type. They should all be General rows. Copy the formula from the first cell and adjust any relative cell references to the new column; or just right click Paste Special Value -->Values Only. Copy the changed formula down and the SUM function should then miraculously spring to life