countif function

J

jpmurray22

I am having a problem with my count if function. when I enter the formula in
the formual panel it give me the correct answer, but when i press enter to
view the formula on the spread sheet it does not show the answer but just the
formula

any help would be appreciated
 
R

Roger Govier

Hi

It sounds as though the cell with the formula has been formatted as Text.
Format>Cells>Number>General
Then edit the formula again.
 
Top