I want to find out how many times a number ends in .05, .10 , .15 etc. in the excel sheet

As the data runs in thousands it is not possible to do it manually

The excel sheet has number like 10.05, 65.35, 75.80 etc. (all multiples of 5 paisa)

I shall be grateful if the members can give me the solution

Thanks for advising