I would like to sum values in columns A,C,an E (odd columns). I have
analysis toolpak installed so that the formula =ISODD(1) returns TRUE

However this formula entered as an array formula (Ctrl-Shift-Enter)
returns #VALUE
=SUM(( ISODD(COLUMN(A2:E3)))*A2:E3)


I developed my own formula without using ISODD and entered as an array
formula it works

=SUM(MOD(COLUMN(A2:E3),2)*IF(ISNUMBER(A2:E3),A2:E3 ,0))

=MOD(COLUMN(A2),2) gives the same results as =ISODD(COLUMN(A2))

Any idea why the ISODD array formula returns an #VALUE

Thanks
Laurence