# Why am I getting ### in some of my cells?

I am trying to do simple calculations in the spreadsheet. The grid I am using is currently in the border of AH horizontal and 30 vertical the cells consist of simple whole numbers. In my equation cell (AJ) I type in the following formula; =SUM(C2+E2+F2+I2+K2+L2+N2+P2+U2+Y2) and I then copy that formula down the column to line 30 but when I hit enter I am only getting numbers in about half of the cells. The other cells only show ###. The column is obviously wide enough because it is showing answers in some of the cells. I have tried manually entering the formula in each and every cell that shows ### but that does not work either. I am just not sure what I am doing wrong. Any help would be appreciated. Thanks.

Your logic is faulty. Just because some results are of a size to fit in the width of a column doesn't mean ALL results are of that size or smaller. Widen the column!

Yes I understand your pov but the numbers are all currently of the same width (only 2 characters wide) but I did change the width just to see and the problem still exists but it has changed. Now instead of showing ### it is showing #VALUE in the cells. Thank you for your input and if you can think of anything else let me know.

Verify the contents of the cells within the sum where you are getting the error. You probably have a non numeric character within.

Yeah I thought about that as well. The cell contents are either all simple whole numbers or blank cells.

At this point it appears only a posted sample may help.

Did you try to print out? Sometimes, Calc shows hash symbols when it can't properly render numbers on the screen, but a printout is fine. In such a case, either zoom in or try changing the font.