Count Whole / Integer Only?
 

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

Answer: Count Whole / Integer 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.

Count Whole / Integer Only?
 

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

Count Whole / Integer Only?
 

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?