Re: Sum every second cell

[Howard Groves <hgroves@1ST.NET>]

I'm sure someone will have something better, but this seems to work as long
as the numbers don't have blanks in between. You will have to array enter
the following formula. You will also have to adjust the range accordingly.
Don't ask me to explain it because I stole it from John Walkenbach's
Formulas book, maybe someone else can help with that part :-) HTH.

=SUM(IF(MOD(TRANSPOSE(ROW(INDIRECT("1:"&COUNT(C3:K3))))-1,2)=0,C3:K3,""))




                                                       Howard G.
                                                       hgroves@1st.net
----- Original Message -----
From: "Kylie Manning" <kamtech@OZEMAIL.COM.AU>
To: <EXCEL-G@PEACH.EASE.LSOFT.COM>
Sent: Thursday, July 24, 2003 5:14 PM
Subject: Sum every second cell


> Hello Everyone
>
> I was wondering if someone could please help.
>
> I need to create a sum function that will add the cell on row 3 for
> every second column.
>
> eg
>
> =sum(C3,E3,G3,I3,K3 ....)
>
> As I have about 50 cells to add the manual method will take me forever
> and risks errors.  Does anyone have a better way?
>
> Many thanks
> Kylie
>
>
> --------------------------------------------------------------------------
> The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
> international's LISTSERV(R) software.  For subscription/signoff info
> and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
>                              COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
>

--------------------------------------------------------------------------
The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info
and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G