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

1. Select the cell where you want to display the result of the count.
2. Type the formula "=COUNTIF(range,"=int(range))" into the formula bar. Replace "range" with the actual range of cells that you want to count.
3. Press Enter to apply the formula.

For example, if you want to count the number of whole numbers in the range A1:A10, you would type "=COUNTIF(A1:A10,"=int(A1:A10))" into the formula bar and press Enter.

This formula works by using the INT function to round each number in the range down to the nearest integer. The COUNTIF function then counts the number of cells in the range that match the rounded-down value. This will give you the count of whole numbers or integers only in the range.

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

To count how many values in a range are integers
=SUMPRODUCT(--(B21:B25=INT(B21:B25)))
which is not an array formula
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"1.4 1.6 2.7 3.1" <1.4 1.6 2.7 wrote in
message ...
How
do I
Count a Range
of whole-numbers / integers only?