+ Reply to Thread
Results 1 to 5 of 5

How to sum sub-sums in adjacent column

  1. #1
    Registered User
    Join Date
    08-04-2011
    Location
    Ocean Grove, Australia
    MS-Off Ver
    Excel 2007
    Posts
    7

    How to sum sub-sums in adjacent column

    I'm a newbie but i have posted this once before. The answer I received worked with with the spread sheet snippet but not the full sheet.
    I would like to place a formula in all the cells of columns O,AD and AS which would sum the sub-totals in the adjacent columns. The ranges of these sub-totals is as defined by the red 's' and red 'f ' in columns D,S and AH.
    I hope the file GSC 2012 bookings is attached.
    There is no urgency with this.
    thanks in advance for any help.
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: How to sum sub-sums in adjacent column

    Hi buffbill,

    See the attached file where I have applied the required formula and highlighted it with yellow. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    Attached Files Attached Files
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    08-04-2011
    Location
    Ocean Grove, Australia
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: How to sum sub-sums in adjacent column

    Unfortunately when I copy that formula up and down from the cell it is entered into, the same sum appears in all the cells above and below it----when I want it to show zero until I enter some new data when it should sum the new values appropriate to that booking. Could this be corrected?

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: How to sum sub-sums in adjacent column

    Hi buffbill,

    May be your are ignoring the sum condition... formula will add the values from "s" till "f"... and this is what formula is doing.
    Try shifting "f" little down and fill out the corresponding values, you will find that formula is automatically updating and summing up the new values. Hope this helps.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  5. #5
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: How to sum sub-sums in adjacent column

    Also, if you want the formula to appear only when you enter "f", then update that as shown in column AS in yellow in the attached file. Thanks.



    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    Attached Files Attached Files

  6. #6
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: How to sum sub-sums in adjacent column

    @DILI,
    Other pairs of (s,f) may appear up and below of current position.
    Simply that to find if current row has "s", to match first "f" and use OFFSET, else returns "blank"

    In O20:
    Please Login or Register  to view this content.
    Copy up and down an accross to AD,AS column.

    Hope this help!
    Quang PT

+ 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