COUNTIF function - results are the formula only

D

Deborah R

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?
 
D

Dave Peterson

Try formatting that cell as General (or anything but text)
then select the cell, hit F2, then enter (to reenter the formula)

If that doesn't work, make sure you're not looking at formulas:
tools|Options|View tab|make sure Formulas is not checked.
 
D

Deborah R

Thank you both, Dave and Toppers...I had the cell formatted as Text. Changing
it to general worked! :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using <= in countifs statement 1
Need help with using Month as criteria for SUM(COUNTIFS(... 3
Finding the weighted average of text that have been given values 1
countifs Function not giving desired result with date criteria 2
Countif, index and match 2
Counting records in a column range occuring between specific dates 4
A useful AVERAGE calculation without using the built-in AVERAGE function 3
Problems with count, counta and countifs 6

Top