Results 1 to 4 of 4

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

Threaded View

  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

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