Count cells greater than 1 & contains a decimal

[Big Chipper]

Hi,

I need to do a count in a column of numbers (m2:m548633) where I need only those numbers greater than 1 and contains also has a decimal.

Any help is appreciated.

 

[jasonb75]

As long as the column only contains proper numbers (no text or formula blanks) then this should work.

=SUMPRODUCT((M2:M548633>1)*(MOD(M2:M548633,1)>0))