nested formula organize odds and evens number

[febausa]

Please see the attach file. I want a formula for organize odd s and even numbers

 

[NARAYANK991]

Hi ,

Something like this ?

Narayan

 

[Oxidised]

a combination sumproduct and mod!!
for odds: =SUMPRODUCT(--(MOD($B2:$F2,2)=1))
for evens: =SUMPRODUCT(--(MOD($B2:$F2,2)=0))

PS - bah Narayan, you always beat me!

 

[Debraj]

Hi febausa..

another option..

Excel already have function to check if Number is Even / Odd.. which looks like doesn't work with range.. but you can tweak it a bit..

In G2 =SUMPRODUCT(ISODD(B2:F2+0)+0)

and if need the final answer in G7.. and dont need those.. G2:G4.. you can use..
In G7 =SUMPRODUCT(--ISODD(B2:F4+0))

For EVEN.. change ISODD to ISEVEN

 

[NARAYANK991]

Hi Deb ,

This also works : =ISODD(--B6:F6)

Narayan

 

[febausa]

Great formula is working, thank you, Narayan

 

[Somendra Misra]

Hi Febausa,

Just to add on @Debraj formula apply below formulas if your range can contain blank cells.

=SUMPRODUCT(ISEVEN(C2:G4+0)*(C2:G4<>""))

Regards,

 

[febausa]

a combination sumproduct and mod!!
for odds: =SUMPRODUCT(--(MOD($B2:$F2,2)=1))
for evens: =SUMPRODUCT(--(MOD($B2:$F2,2)=0))

PS - bah Narayan, you always beat me!

Very good answer. the formula working very well.
Thank you,
FEBAUSA