Help with Formula using Analysis ToolPack Function ISODD

[Tinä]

Hi Peo,

Thank you for all your time and help: the formula works perfectly.

Tinä

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 wa I
can avoid manually changing the Row Index number (after ROOMS) fo each
Row so that I can just copy / fill the formula down. I tried th ROW
function but did not get the correct answer.

Further assistance appreciated.

Thanks
Tinä