counting in exel chart
 

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

counting in exel chart
 

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

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

--
Don Guillett
SalesAid Software

"brian exel" wrote in message
...
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

counting in exel chart
 

Thank you for your quick response
--
brian exel 2003


"Don Guillett" wrote:

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

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

--
Don Guillett
SalesAid Software

"brian exel" wrote in message
...
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

counting in exel chart
 

I assume that this solution was good.

--
Don Guillett
SalesAid Software

"brian exel" wrote in message
...
Thank you for your quick response
--
brian exel 2003


"Don Guillett" wrote:

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

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

--
Don Guillett
SalesAid Software

"brian exel" wrote in message
...
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

counting in exel chart
 

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