View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_2_] Alan Beban[_2_] is offline
external usenet poster
 
Posts: 783
Default How to obtain sum of odd numbered column

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