SOLVED

New Contributor

# 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?

4 Replies
best response confirmed by MarcelLaib (New Contributor)
Solution

# Re: Count all numbers with the decimal place 0.005

This formula counts the cells containing the number 5:
=COUNTIF(A1:A100,5)

# Re: Count all numbers with the decimal place 0.005

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.

# Re: Count all numbers with the decimal place 0.005

``=COUNT(SEARCH("*5*",C5:C22))``

You can try this formula if you want to count the cells that contain 5. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.

``=SUMPRODUCT(N(ROUND(C5:C22/0.005,0)=(C5:C22/0.005)))``

You can try this formula if you want to count the cells that are a multiple of 0,005.

# Re: Count all numbers with the decimal place 0.005

It doesn't work with office365