+ Reply to Thread
Results 1 to 6 of 6

Sum skipping columns

  1. #1
    Steve
    Guest

    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. #2
    Duke Carey
    Guest

    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. #3
    Duke Carey
    Guest

    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. #4
    Don Guillett
    Guest

    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
    news:60A52AB5-3A40-4759-91AD-35CE2D18FA0C@microsoft.com...
    > 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. #5
    Steve
    Guest

    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. #6
    Don Guillett
    Guest

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




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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