Count whole numbers that are greater than zero in a column that aslo has in percentages

[headley4ever]

Greetings Experts,

Can any of you help me to write a formula that will count only whole numbers that are greater than zero (0) in a column that also consist of percentages.

Example: In column A1: A120 you have whole numbers and percentages eg: ( 0, 10, 17,14%, 7, 9, 25%, 11%, 0, 12, 14% etc..). I need to write a formula in cell A121 that will count all the whole numbers that are greater than zero and ignore the percentages%.

I hope my explanation is clear.

Thanks,
Headley

[Pepe Le Mokko]

Try =SUMPRODUCT(--(MOD(A1:A120,1)=0)*(A1:A120>0))

[zbor]

Here, try this:

Please Login or Register  to view this content.

[headley4ever]

Thank you .. Your formula works perfect.

[zbor]

Just to be clear:
Each will return different result if 0 is in your cells.

If you have:

Please Login or Register  to view this content.

Mine will return 7 (0,10,17,7,9,0,12)
while Pepe Le Mokko will return 5 (10,17,7,9,12).

Take what is best for you.

[Pepe Le Mokko]

all the whole numbers that are greater than zero

Wasn't that what the OP requested ?

[zbor]

Just wanted to point that out for this user and for all other that see this thread.