I have 31 cells going left to right that all have whole numbers, (no formulas). In the 32nd cell, I am trying to use the SUM formula to add all the cells. Here is where the problem lies. I used the standard =sum(c2:ag2), however, upon hitting enter, only the formula will show up in the cell. I worked on this for a while, and finally got =sum(c2+d2+e2.....) to work, but I noticed I had accidently left out one cell. When I went back in to correct this, (adding the cell in the same manner as all the other cells), again only the formula would show up and not the added sum. I am working on Office 98, Macintosh. This is the only time I've ever had a problem using formulas. Does Excel have a limit to the number of cells that can be used in a formula? Does Excel have a hard time working left to right? How can I get this to work?