countif function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi

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