Count cells with numbers and text but only want cells with number counted

Question

My statistics record of our flighted golf league, records scores and letter entries for did-not-finish, absent and absent with substitute.

I want to count the number of player who played, by using their scores but not include any text entries.

The count total cell is: =COUNT(H6,H9,H12,H15,H18,H21,H24,H27,H30,H33). If H9 and H24 did not play an "X" is entered.

Formatting all cells as Numbers will still count the "X" in the total.

TIA

harun24hr · Answer

COUNT() function will not count "X" never, ever. Can you please share a sample file where you getting wrong result?

davehill · Answer

I found the error.&nbsp; Thanks for your reply.

Forum Discussion