countif is not really a good match for this purpose

=sumproduct(--(floor(mod(A1:A8,1),0.1)=.2))
should do what you want



"Graham" wrote:

Hi, I want to count the occurence of the first decimal place only in a range
of numbers. The "COUNTIF" function in B1 will work for a whole number as
shown below, but if i want the number of times .2 occurs, ignoring all other
intergers and decimal places. Can I adapt this function for this?

=COUNTIF(A1:A8,"4567.21")


A B
1 1234.35 1
2 2345.78
3 3456.98
4 4567.21
5 5678.23
6 6543.56
7 6754.82
8 3452.45