Odd and even numbers in the range

[bines53]

Hello Friend !

I want to get the result as in cells H15, I15 without the use of help columns.

Thank you !

 

[NARAYANK991]

Hi David ,

Try these array formulae , to be entered using CTRL SHIFT ENTER :

=SUM(--(MMULT(--(MOD($A$2:$F$12,2)=0),TRANSPOSE(COLUMN($A$2:$F$12)^0))=3))

=SUM(--(MMULT(--(MOD($A$2:$F$12,2)=1),TRANSPOSE(COLUMN($A$2:$F$12)^0))=4))

Narayan

 

[bines53]

Hi Narayan ,

Excellent !!!

Thank you !

David

 

[Luke M]

Ah, the mysterious MMULT...I had a feeling we would need to use it's dark powers in order to do this.

 

[bines53]

You can also use this formula Without {}
=SUM(--(MMULT(--(MOD($A$2:$F$12,2)=0),{1;1;1;1;1;1})=3))
=SUM(--(MMULT(--(MOD($A$2:$F$12,2)=1),{1;1;1;1;1;1})=4))

 

[Somendra Misra]

Hi David,

Just another alternative using MMULT:
In H15:
=SUMPRODUCT(--(MMULT(--ISEVEN(--$A$2:$F$12),{1;1;1;1;1;1})=3))

In I15:
=SUMPRODUCT(--(MMULT(--ISODD(--$A$2:$F$12),{1;1;1;1;1;1})=4))

Regards,

 

[bines53]

Hi Somendra,

Excellent ,A great idea !

Where SUMPRODUCT can be SUM .

Thank you !