Help with Formula using Analysis ToolPack Function ISODD

[Tinä]

Hi Peo,

Thank you, but this workaround gives me the* total * number of Od
numbers for the complete Dynamic Named Range ROOMS.

=SUMPRODUCT(--(MOD(ROOMS,2)=1))

Is it possible to get the *count of Odd numbers per/ for eac
individual Row of 9 Columns* using the Dynamic Named Range ROOMS.

Thanks
Tinä

One workaround
=SUMPRODUCT(--(MOD(ROOMS,2)=1))

Regards,
Peo Sjoblom

 

[Peo Sjoblom]

Sure, just use index as well, for the first row you can use

=SUMPRODUCT(--(MOD(INDEX(ROOMS,1,),2)=1))

just change the 1 after ROOMS to whatever row you want to count

Regards,

Peo Sjoblom

Hi Peo,

Thank you, but this workaround gives me the* total * number of Odd
numbers for the complete Dynamic Named Range ROOMS.

=SUMPRODUCT(--(MOD(ROOMS,2)=1))

Is it possible to get the *count of Odd numbers per/ for each
individual Row of 9 Columns* using the Dynamic Named Range ROOMS.

Thanks
Tinä