ISODD array formula
 

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

ISODD array formula
 

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2