Is it only the COUNTIF formula that shows up as text or does any formula
show up as text? If any formula shows up as text than the cell you
entered the formula in was probably formatted as text prior to entering
it. Delete the COUNTIF formula and check that cell's format. If it is
Text then change it to General and re-enter your formula. If it is not
text then check under Tools/Options/View Tab to see if in the Window
View area the check box next to formulas is selected. If it is, all
formulas in your sheet will be visible and not their results.

HTH

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=495346