+ Reply to Thread
Results 1 to 4 of 4

SUMMING Consecutive columns

Hybrid View

tantcu SUMMING Consecutive columns 05-28-2013, 12:23 PM
djapigo Re: SUMMING Consecutive... 05-28-2013, 01:34 PM
tantcu Re: SUMMING Consecutive... 05-28-2013, 01:45 PM
wfm007 Re: SUMMING Consecutive... 05-28-2013, 01:51 PM
  1. #1
    Forum Contributor
    Join Date
    07-16-2012
    Location
    Fort Worth, Texas
    MS-Off Ver
    Excel 2010
    Posts
    378

    SUMMING Consecutive columns

    Hello

    I have data in row 1 and go from column A to P. Is there a formula that help me SUM numbers following order 4, 4, 5. For example, I want to sum A1:D1, then SUM E1:H1, then SUM I1:M1, continue to do with longer data with a pace of 4, 4, 5.

  2. #2
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: SUMMING Consecutive columns

    tantcu,

    Why can't you just use
    =SUM(A1:D1)
    =SUM(E1:H1)
    =SUM(I1:M1)
    =SUM(N1:Q1)
    =SUM(R1:U1)
    =SUM(V1:Z1)
    etc.

    Am I missing something?

  3. #3
    Forum Contributor
    Join Date
    07-16-2012
    Location
    Fort Worth, Texas
    MS-Off Ver
    Excel 2010
    Posts
    378

    Re: SUMMING Consecutive columns

    Imagine if I have like more than 1000 data. It would be convienence for me to have a set of formula to drag out.

  4. #4
    Forum Contributor
    Join Date
    02-28-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    272

    Re: SUMMING Consecutive columns

    If possible attach the sample file
    Please consider adding a * if I helped

+ 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