ISODD array formula

[Laurence Lombard]

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

 

[Claus Busch]

Hi Laurence,

Am Fri, 04 May 2012 13:27:14 +0200 schrieb Laurence Lombard:

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

try:
=SUM(IF(ISODD(COLUMN(A:E)),A2:E3))
array formula to enter with CTRL+Shift+Enter


Regards
Claus Busch