Results 1 to 7 of 7

Sum number range with two sets of criteria listed with merged cells

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2016
    Location
    Beverly Hills, CA
    MS-Off Ver
    Office 2013
    Posts
    3

    Sum number range with two sets of criteria listed with merged cells

    Hey, everyone!

    I've been searching for a formula to solve this one, to no avail it seems...

    On the Data tab, but displayed on the Simplified tab, I'd like to sum the numbers listed in column C if the it matches the adjoining cells in both A and B columns.

    I tried using this formula, but it didn't work...

    =SUMIFS(Data!C:C,Data!A:A,"Jason",B:B,"Calls")

    I feel like I have the ability to be very specific with the information, just haven't figured out how to point it in the right direction.

    Any ideas?

    Thanks in advance, guys!
    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. [SOLVED] SUMIFS with one criteria range that contains merged cells
    By r4square in forum Excel General
    Replies: 5
    Last Post: 03-18-2015, 04:33 AM
  2. [SOLVED] Formula or VBA or Combination to count Number of Cells in a merged range! PLEASE HELP!
    By WaylettChris in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-13-2014, 11:02 AM
  3. Replies: 4
    Last Post: 06-13-2014, 07:08 PM
  4. Replies: 1
    Last Post: 05-21-2014, 02:30 PM
  5. [SOLVED] Formula to use to count the number of cells in a column which meet three sets of criteria
    By Dhabitude in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-11-2013, 11:22 AM
  6. [SOLVED] Trying to count the number of cells that meet two sets of Criteria
    By Pablo12 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-24-2013, 12:02 PM
  7. [SOLVED] for SUMIF function, how do I use 2 sets of range & criteria
    By Bob in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-10-2006, 03:55 PM

Tags for this Thread

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