Count Whole / Integer Only?

[1.4 1.6 2.7 3.1]

How
do I
Count a Range
of whole-numbers / integers only?

 

[Jarek Kujawa]

provided there are no empty cells in A1:A10 try:

=SUM(IF($A$1:$A$10=INT($A$1:$A$10),1,))

this is an array formula so insert it with CTRL+SHIFT+ENTER

 

[Bernard Liengme]

To count how many values in a range are integers
=SUMPRODUCT(--(B21:B25=INT(B21:B25)))
which is not an array formula
best wishes