Help with Formula using Analysis ToolPack Function ISODD

[Tinä]

Hi Peo,

Thank you for assistance. The formula is fine - but is there a way
can avoid manually changing the Row Index number (after ROOMS) for eac
Row so that I can just copy / fill the formula down. I tried the RO
function but did not get the correct answer.

Further assistance appreciated.

Thanks
Tinä

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

 

[Peo Sjoblom]

This works for me

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

copied down, if you copy accross replace
ROW(1:1) with COLUMN(A:A)

Regards,

Peo Sjoblom

Hi Peo,

Thank you for assistance. The formula is fine - but is there a way I
can avoid manually changing the Row Index number (after ROOMS) for each
Row so that I can just copy / fill the formula down. I tried the ROW
function but did not get the correct answer.

Further assistance appreciated.

Thanks
Tinä