countif problem

[kelley_aj]

O.K. I did a search and could not find an answer to my problem. I am trying to do a very simple coutif function =COUNTIF(B4:AG4,"=A") where I am trying to count the number of "A" are in the row B4:AG:4. It works fine until it gets to more than 9 occurances and yields a # sign in the cell. If I go to format cell it shows the correct number, but displays # instead of the number itself. Any ideas as to what I am doing wrong?

Thanks

 

[texasalynn]

make the width of your column wider

 

[kelley_aj]

OMG I can not believe I did not recognize that!! I feel like such a Homer!! Thanks a million I will crawl respectfully back to my mouse sized hole!! :wink: