Count Function?
 

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?

Count Function?
 

One way:

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

In article ,
jayceejay wrote:

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?

Count Function?
 

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" wrote:

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?

Count Function?
 

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

"JE McGimpsey" wrote:

One way:

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

In article ,
jayceejay wrote:

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?