counting in exel chart

[brian exel]

I have columns of numbers some are interger number some are numbers with
decimal places. I want to count the number of integer numbers in each column
any ideas which formula I use. I have tried countif but cant find anyway of
specifying the integer number?

 

[Don Guillett]

this is an array formula which must be entered using
ctrl+shift+enter

=COUNT(IF(MOD(H3:H6,1)=0,H3:H6))

 

[brian exel]

Thank you for your quick response

 

[Don Guillett]

I assume that this solution was good.

 

[Teethless mama]

Try this:

=SUMPRODUCT(--(MOD(A1:A12,1)=0))