Count Function?

  • Thread starter Thread starter jayceejay
  • Start date Start date
J

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?
 
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
 
A thousand thanks to the both of you -- Both very helpful. I appreciate it
immensely.
 
Back
Top