count cell which round down

[j.farr3ll]

Hi all,

I'm trying to find a formula which will count the number of cells with a decimal point equal to or less than .5 but not 0.

For example if my dataset in column A was:

5.5
6.7
4.0
3.2
4.6
1.1
9.5
3.0

I'd want the formula to return 4 because 4 of the 8 values have a decimal of .5 or less.

Any help would be gtreat.

Thanks,
James

[Ace_XL]

=sumproduct((mod(a1:a8,1)<=0.5)*(mod(a1:a8,1)<>0))

[j.farr3ll]

Great Thanks

[alansidman]

In column B, =A1-INT(A1) and copy down

In column C, =COUNTIFS(B1:B8,">0",B1:B8,"<=.5")