Can you post your formula with a bit of explanation of your data layout
and values etc? Then we might be able to offer more explicit advice.

Pete

wrote:

I followed the help menu to try to use the countif function, but it
just doesn't work out. I used direct copy from the excel help menu, so
that the function could not possibly has any typo problem. Can anybody
tell me why my countif problem doesn't recognized by office? thx.