Sum skipping columns

In cell DC9 I want to enter a formula that will give me the sum of
E9+H9+K9+N9+...(every third column in row 9). Is this possible without
having to type out =E9+H9+...?

=SUMPRODUCT(C9:N9,--(MOD(COLUMN(C9:N9)-2,3)=0))

"Steve" wrote:

> In cell DC9 I want to enter a formula that will give me the sum of
> E9+H9+K9+N9+...(every third column in row 9). Is this possible without
> having to type out =E9+H9+...?

Oops-

=SUMPRODUCT(E9:Z9,--(MOD(COLUMN(E9:Z9)-2,3)=0))

"Duke Carey" wrote:

> =SUMPRODUCT(C9:N9,--(MOD(COLUMN(C9:N9)-2,3)=0))
>
> "Steve" wrote:
>
> > In cell DC9 I want to enter a formula that will give me the sum of
> > E9+H9+K9+N9+...(every third column in row 9). Is this possible without
> > having to type out =E9+H9+...?

try this for row 4. correct for word wrap
=SUMPRODUCT((MOD(COLUMN(E4:INDEX(4:4,100))-CELL("Col",E4)+0,3)=0)*(E4:INDEX(
4:4,100)))
--
Don Guillett
SalesAid Software
[email protected]
"Steve" <[email protected]> wrote in message
news:[email protected]...
> In cell DC9 I want to enter a formula that will give me the sum of
> E9+H9+K9+N9+...(every third column in row 9). Is this possible without
> having to type out =E9+H9+...?

Worked perfectly. Thanks...huge timesaver.

"Duke Carey" wrote:

> Oops-
>
> =SUMPRODUCT(E9:Z9,--(MOD(COLUMN(E9:Z9)-2,3)=0))
>
> "Duke Carey" wrote:
>
> > =SUMPRODUCT(C9:N9,--(MOD(COLUMN(C9:N9)-2,3)=0))
> >
> > "Steve" wrote:
> >
> > > In cell DC9 I want to enter a formula that will give me the sum of
> > > E9+H9+K9+N9+...(every third column in row 9). Is this possible without
> > > having to type out =E9+H9+...?

Nice

--
Don Guillett
SalesAid Software
[email protected]
"Duke Carey" <[email protected]> wrote in message
news:[email protected]...
> Oops-
>
> =SUMPRODUCT(E9:Z9,--(MOD(COLUMN(E9:Z9)-2,3)=0))
>
> "Duke Carey" wrote:
>
> > =SUMPRODUCT(C9:N9,--(MOD(COLUMN(C9:N9)-2,3)=0))
> >
> > "Steve" wrote:
> >
> > > In cell DC9 I want to enter a formula that will give me the sum of
> > > E9+H9+K9+N9+...(every third column in row 9). Is this possible
without
> > > having to type out =E9+H9+...?

similar question, in a column, if i want to sum up every 13th cell moving down, i.e. starting at D5, then D18, D31, etc. i tried to modify the above but am having no luck

thanks!

will do, thanks!