How to obtain sum of odd numbered column

[perseus]

Hi All,

I want to obtain the sum of odd numbered column, like A6, C6, E6.... How can
I do that in a formula ?

Thanks.

Simon

 

[Alan Beban]

Hi All,

I want to obtain the sum of odd numbered column, like A6, C6, E6.... How can
I do that in a formula ?

Thanks.

Simon

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are availablre to your workbook

=SUM(ArrayAlternates(A6:IV6,,False))

Alan Beban

 

[Tom Ogilvy]

=SUMPRODUCT(N(MOD(COLUMN(A6:M6),2)=1),A6:M6)