Countif for a multiselect column
Hello,
I have a multi select column with numbers in one sheet. I have another summary sheet where I am counting how many times all the numbers have appeared in the first sheet. The countif formula is giving the wrong answer for the numbers with second decimal place 0.
For example, if the number I want to count is 70.80, then along with counting how many times 70.8 has appeared, it is also counting 70.81, 70.82 etc. But the formula will count properly if the number is 70.81 or 70.83 etc.
Here are formulas I have tried 
Countif({range in first sheet}, FIND(number@row,@cell)>0)
Countif({range in first sheet}, CONTAINS(number@row,@cell))
Countif({range in first sheet}, HAS(number@row,@cell))
Any help is appreciated.
Answers

Hi @Tanu Harsha
Hope you are fine, please try the following formula:
=COUNTIF({Range in first sheet}, HAS(@cell, number@row))
the following screenshots shows the results:
The Numbers Summary
The Number Database
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

I have tried that and it did not work. There is also a condition that the checkbox has to be checked to count the row. I added the screenshots for your reference. Column 3 on the 2nd screenshot has formula that I tried for that row
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!