Forum Discussion
Solved
Count all numbers with the decimal place 0.005
Hello, i need to count all numbers with the number 5 from a list. How does it work?
- This formula counts the cells containing the number 5:
=COUNTIF(A1:A100,5)
This formula counts the cells containing the number 5:
=COUNTIF(A1:A100,5)
=COUNTIF(A1:A100,5)
Yes that is okay. But i want additionally to count the number 5 in numbers like 65 or 185.
So i have a list with the numbers:
0,5,10,15,20,25,30,35,40,45,50,55,60
The result should be 6.
So i have a list with the numbers:
0,5,10,15,20,25,30,35,40,45,50,55,60
The result should be 6.