Help with Formula using Analysis ToolPack Function ISODD

[Tinä]

Hi,

Is this feasible using the Analysis ToolPack function ISODD -

Can I avoid using individual column/cell references to count th
instances of ODD numbers: I have a Dynamic named Range called ROOM
that spans 9 columns (and many rows) with an OFFSET of 1 for a colum
heading.

The Define Name Refers To Box for ROOMS is:
=OFFSET(LOCATION!$C$18,1,0,COUNTA(LOCATION!$C:$K),9)

Rather than using individual cell references , can I use this Dynami
Named Range ROOMS to find the total count of Odd numbers within eac
row of 9 columns - can this be done?

Thanks
Tin

 

[Peo Sjoblom]

One workaround

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

Regards,

Peo Sjoblom