View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default COUNTIF function - results are the formula only

The cell is (likely to be) formatted as TEXT: change to GENERAL and hit enter.

"Deborah R" wrote:

I'm working with game stats. I'm simply trying to count the number of "W"s in
a column as opposed to "L"s. I've entered =COUNTIF(O2:O56,"W"). My result is
the formula rather than the count. What am I doing wrong?