Count non prime numbers only

[jsk_lge]

I have many numbers in a colum. I want to count only those numbers which are divisible by 2.
which formula should I use?

 

[Swapnil]

You can use following formula , replace B4:B79 with the range for which you want to check.

=SUMPRODUCT(--IF(MOD(B4:B79,2)=0,1))

This being an array formula , dont forget to press ctrl+Shift+enter.

 

[NARAYANK991]

Hi ,

Try this non-array entered formula :

=SUMPRODUCT(--(MOD(List,2)=0))

Narayan

 

[jsk_lge]

Thanks Narayan, your formula works.

 

[Somendra Misra]

@jsk_lge

Here another non array formula:

=SUMPRODUCT(--ISEVEN(--(range of number)))

Regards,

 

[Hui]

Your posts Title and Inside Question are not totally compatible
The title "Count non prime numbers only"
implies to count non-prime numbers only

Although all Even Numbers aren't Prime

Many OddNumbers aren't prime as well,
eg: 9, 15, 21, 25, 27 etc

Just thought I'd check?