Aug 08 2022 04:35 AM
Hello,
i need to count all numbers with the number 5 from a list.
How does it work?
Aug 08 2022 04:45 AM
SolutionAug 08 2022 04:52 AM
Aug 08 2022 05:01 AM
=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.
Aug 08 2022 05:36 AM
Aug 08 2022 04:45 AM
Solution