Hi,
if it shows the function formula press

CTRL + Caps Lock + ~

~ is at the left of number one in your keyboard

"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