# Sum skipping columns

1. ## 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+...?

2. ## RE: Sum skipping columns

=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+...?

3. ## RE: Sum skipping columns

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+...?

4. ## Re: Sum skipping columns

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
donaldb@281.com
"Steve" <Steve@discussions.microsoft.com> wrote in message
> 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+...?

5. ## RE: Sum skipping columns

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+...?

6. ## Re: Sum skipping columns

Nice

--
Don Guillett
SalesAid Software
donaldb@281.com
"Duke Carey" <DukeCarey@discussions.microsoft.com> wrote in message
news:0F8453E5-8BC3-44A2-B594-DDE839FDDC24@microsoft.com...
> 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+...?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1