Hi
I need a formula that counts the second number after punctuation(full stop/comma)
Ex, count number of cells from A1:A20, that ends with 0, or ends with 1. The numbers are with decimals, like 1.34, 1.37 1.00 1.56, 1.50 and so on. They are sometimes longer as well, like 1.4320, or 23.4567
However, I only want the second number after punctuation(full stop/comma).
So a number that is like: 1.4378
I only want it to count the number 3
A number that is like this: 25.607, I only want to count the number 0
I'v tried with this formula, but can't get it to work correctly
=SUMPRODUCT(--(RIGHT(A1:A20)="1"))
Bookmarks