Forum Discussion
COUNTIF help
I have used COUNTIF several times before. But on this particular sheet it doesn't want to function. I am getting 0 when I should get 3. If i substitute "*" it counts all the cells. When I type ou...
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.
- Thank you. I'll double check that.
- Thank you. I have no idea how the space got in there. Works Great!
- Now is possible to have the wins sorted descending automatically as the wins change?
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).
