The cell may have been formatted as text.

Format to General then F2 + ENTER.


Gord Dibben MS Excel MVP


On Fri, 4 Jan 2008 11:11:00 -0800, donna
wrote:

I am trying to use the countif formula to count on an excell spread sheet, I
dont have numbers in the colum I have X, I have used the following formula
=countif(a1:A12,"X") but when I hit the enter button or the control shift
enter button nothing is adding, all it shows is the formula I but in. Please
Help!