+ Reply to Thread
Results 1 to 4 of 4

SUMIF - Summing Data from several specified cells based on data of corresponding cells

  1. #1
    Registered User
    Join Date
    01-24-2014
    Location
    Scottsdale
    MS-Off Ver
    Excel 2013
    Posts
    35

    SUMIF - Summing Data from several specified cells based on data of corresponding cells

    On the "CurrentCustomer" worksheet tab I am trying to accomplish the following:
    When the merged cells in the F column (F3, F25, F47...F443) equal the word "Contract", I need the corresponding total cells in the E column (E23, E45, E67...E463) to add up, if and only if the corresponding F column merged cell equals "Contract".

    For example, using the first three ranges, if F3, F25, & F47 all equal "Contract", I need the corresponding E23, E45, & E67 to add up. If F3 & F47 equal "Contract", but F25 equals anything other than contract I need E23 & E67 to add up only.

    Thanks,
    Attached Files Attached Files

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: SUMIF - Summing Data from several specified cells based on data of corresponding cells

    Using your posted workbook...
    This regular formula returns the sum of Col_E totals where the corresponding Buying Agreement cell equals "contract"
    Please Login or Register  to view this content.
    • Notice the offset of the referenced ranges.

    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    01-24-2014
    Location
    Scottsdale
    MS-Off Ver
    Excel 2013
    Posts
    35

    Re: SUMIF - Summing Data from several specified cells based on data of corresponding cells

    Thanks Ron, that worked!

  4. #4
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: SUMIF - Summing Data from several specified cells based on data of corresponding cells

    Glad you got something you can use!

    If that resolves your issue, please take a moment to mark this thread as SOLVED (from the Thread Tools menu)

+ 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. Need Help with summing cells in a table using the SUMIF with Index/Match
    By Sun144 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-17-2013, 04:07 PM
  2. Replies: 4
    Last Post: 08-22-2012, 12:18 PM
  3. Replies: 2
    Last Post: 08-27-2010, 07:04 AM
  4. Summing Data with the same Values in Adjacent Cells
    By soorty in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2010, 10:52 PM
  5. Summing up cells based on values of other cells
    By ramakavin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-26-2008, 03:19 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