Try this:

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


"brian exel" wrote:

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?
--
brian exel 2003