I have tried to add a column that is not responding. I copied the numbers to the next column one at a time and then =SUM and it worked. I understand that the first column is being considered text as there are equation there adding the horizontal information. However, after trying the previous response it is still just adding to zero. I've tried turning it off and turning it back on, asking a co-worker and your help here! Maybe I'll just go home for the day and try again tomorrow.