Count Function?

[jayceejay]

I have a column in a list that contains several numbers, some of which are
integers and others which have decimal points. Is there a way to count those
cells in a column that contain decimals?

 

[JE McGimpsey]

One way:

=SUMPRODUCT(--(INT(A1:A100)<>A1:A100))

 

[Sheeloo]

Suppose you have your numbers in A1:A100 then type this in any cell other
than A1:A100

=SUM(IF(A1:A100-INT(A1:A100)>0,1,0))
and press CTRL-SHIFT-ENTER to get the count

 

[jayceejay]

A thousand thanks to the both of you -- Both very helpful. I appreciate it
immensely.