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

perseus wrote:
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

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

--
Regards,
Tom Ogilvy


"perseus" wrote in message
...
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