+ Reply to Thread
Results 1 to 4 of 4

Help needed combining SUM OFFSET MATCH with condition

  1. #1
    Registered User
    Join Date
    01-22-2017
    Location
    manchester,england
    MS-Off Ver
    2016
    Posts
    9

    Help needed combining SUM OFFSET MATCH with condition

    Hi There

    I would be grateful if someone could advise me how to achieve the conditional sum in cell b4 on the attached spreadsheet.

    The formula which works without a condition doesn't seem to work when I combine it with SUMIF.

    My goal is to total the values under a looked up date, based on the values being stated as full price.

    Thanks

    Richard
    Attached Files Attached Files

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: Help needed combining SUM OFFSET MATCH with condition

    Hi,

    Does this help?

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    01-22-2017
    Location
    manchester,england
    MS-Off Ver
    2016
    Posts
    9

    Re: Help needed combining SUM OFFSET MATCH with condition

    Great, thank you!

  4. #4
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: Help needed combining SUM OFFSET MATCH with condition

    You're welcome..

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combining offset with countif / index and match
    By Bart666 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-03-2019, 09:34 AM
  2. [SOLVED] Making SUMIF and OFFSET MATCH MATCH MATCH MATCH work
    By XL Grasshopper in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-30-2017, 11:12 AM
  3. INDEX MATCH MATCH/OFFSET MATCH MATCH with named ranges
    By Andrew-Mark in forum Excel General
    Replies: 3
    Last Post: 02-27-2015, 10:56 PM
  4. Need help in combining IF into OffSET
    By shuriyan0924 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-27-2015, 04:07 AM
  5. complex formula combo needed, like offset, match, etc
    By turbo600hp in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-31-2013, 04:20 PM
  6. Combining offset, address, and match
    By rhart00 in forum Excel General
    Replies: 2
    Last Post: 04-26-2010, 07:01 PM
  7. Limitations when Combining OFFSET and MATCH to return a cell reference
    By dangermousedale in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-23-2008, 08:39 PM

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