Counting integers (or non-integers)

[Sparky_]

Greetings -

I have a large column of numbers -

I need a count of how many integers are in this column.

How can I quickly do this? Is there a simple method?

Thanks
Sparky_

 

[jeffreybrown]

Hi Sparky,

Sounds like it should just be =Count(A1:A20)

 

[grizz]

you could try

=SUMPRODUCT(--(A:A=INT(A:A))*ISNUMBER(A:A))

 

[Aladin Akyurek]

Greetings -

I have a large column of numbers -

I need a count of how many integers are in this column.

How can I quickly do this? Is there a simple method?

Thanks
Sparky_

If integers are what you are after, not any number, try...

=SUMPRODUCT(--ISNUMBER(A2:A100),--(TRUNC(A2:A100)=A2:A100))

 

[mikerickson]

=COUNT(C1:C10)-SUMPRODUCT(ROUNDUP(C1:C10-INT(C1:C10),0))

Will return the number of integer numbers in C1:C10

 

[T. Valko]

Greetings -

I have a large column of numbers -

I need a count of how many integers are in this column.

How can I quickly do this? Is there a simple method?

Thanks
Sparky_

Maybe this...

Book1
	A	B	C
2	-1	_	4
3	55	_	_
4	0.25	_	_
5	10.23	_	_
6	0.003	_	_
7	1	_	_
8	1.69	_	_
9	-5	_	_
10	-5.3	_	_
Sheet1

Formula entered in C2:

=SUMPRODUCT(--(MOD(A2:A10,1)=0))