COUNTIF help

Question

I have used COUNTIF several times before.&nbsp; But on this particular sheet it doesn't want to function.&nbsp; I am getting 0 when I should get 3.&nbsp; If i substitute "*" it counts all the cells.&nbsp; When I type out what (i.e. "Name") I'm looking for it works, but I have 6 sheets with 40 to 60 names to count on each.&nbsp; I did use a macro to generate a round robin tournament, but that is on a different sheet than the results.&nbsp; Any suggestions?

hansvogelaar · Answer

DerrellSC&nbsp;
Check carefully if there is a space before or after the name in the range where you want to count the name, or another spelling difference.

hansvogelaar · Answer

DerrellSC&nbsp;
You could use the SORT function to return the wins in descending order in another range.
If you want the wins to be sorted automatically in place, that would require VBA (which works only in the desktop versions of Excel for Windows and Mac , not in the online, Android and iOS versions).

derrellsc · Answer

Thank you. I'll double check that.

derrellsc · Answer

Thank you. I have no idea how the space got in there. Works Great!

derrellsc · Answer

Now is possible to have the wins sorted descending automatically as the wins change?

Forum Discussion

COUNTIF help

Share

Resources