Hi Carolyn

If it is showing the function, then the formula has been entered into a
cell that has been formatted as Text.
Right click on the cellFormatCellsNumberGeneral
Once you have done thatF2 to edit cellEnter

--
Regards
Roger Govier

Carolyn wrote:
The count function is not working in one of my workbooks. It works in others
and in new ones. The workbook it is not working in was created last week.
It returns either zero or shows the function formula in the cell even though
calculate is set at automatic.

Carolyn