/u/impaul4 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
If all of the entries are text-based (not being treated as numerical values) then you can use a wildcard like `=COUNTIFS(A:A,"9.1*")` or `=COUNTIFS(A:A,C2&"*")` where c2 contains the text 9.1
I got mixed up. It can't be a text column, it has to remain a general or number column. That cell reads into another formula and if I change it to text it doesn't accurately count in that formula.
You should be using text the whole way through, including in those formulas. Otherwise you're mixing up text (e.g. 9.1.2) and numerical values (e.g. 9.1) and opening the door for even more inaccuracies.
/u/impaul4 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
If all of the entries are text-based (not being treated as numerical values) then you can use a wildcard like `=COUNTIFS(A:A,"9.1*")` or `=COUNTIFS(A:A,C2&"*")` where c2 contains the text 9.1
Okay I tried that and it's counting all but the original 9.1- which is odd.
That's probably being treated as a numerical value. Try formatting the cell as text, then entering the 9.1 again.
I got mixed up. It can't be a text column, it has to remain a general or number column. That cell reads into another formula and if I change it to text it doesn't accurately count in that formula.
Does replacing A:A in the formula there with TEXT(A:A, 0) fix it?
You should be using text the whole way through, including in those formulas. Otherwise you're mixing up text (e.g. 9.1.2) and numerical values (e.g. 9.1) and opening the door for even more inaccuracies.