+ Reply to Thread
Results 1 to 3 of 3

Formula to Sum based on 2 criteria

Hybrid View

  1. #1
    Registered User
    Join Date
    07-28-2009
    Location
    Chicago, Il
    MS-Off Ver
    Excel 2007
    Posts
    67

    Formula to Sum based on 2 criteria

    Good afternoon,
    I have a spreadsheet in which i have to pull out the amount of calls by customer by time frame.
    Column A is "Time Frames" IE 9am, 930am, etc
    Column B is "Customer" IE Customer 1, Customer 2
    Column C is "Calls" this is the number of calls that are made in a specific interval by a specific customer

    Now what i need to do is come up with a formula that i would be able to show that at the 930am interval Customer 1 made 4 calls and Customer 2 made 3 calls.

    Below is a sample of the worksheet i have. can anyone help with this. i have tried. Countifs, Match and Sum but cannot figure out the right Combination to get the numbers i need


    Time Call Work Code ACD Calls
    8:30 AM Customer 1
    8:30 AM Dealer 1
    8:30 AM Customer 1
    8:30 AM Dealer 3
    9:00 AM Dealer 3
    9:00 AM Dealer 1
    9:00 AM Dealer 1
    9:00 AM Customer 1
    9:30 AM Customer 1
    9:30 AM Dealer 2
    9:30 AM Dealer 1
    Last edited by Ricardo9211; 12-28-2010 at 02:09 PM. Reason: Problem Solved

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Formula to Sum based on 2 criteria

    You mention COUNTIFS which implies use of XL2007 or above yet profile implies otherwise... if you can use XL2007+ functions then use SUMIFS (assuming you can't simply use a Pivot Table of course)

    =SUMIFS(C:C,A:A,"9:30 AM",B:B,"Customer")
    obviously constants above can be replaced with cell references containing criteria values

    To reiterate, however, a PivotTable may prove to be a far better option irrespective of XL version [assuming you need to repeat this function for various combinations]

  3. #3
    Registered User
    Join Date
    07-28-2009
    Location
    Chicago, Il
    MS-Off Ver
    Excel 2007
    Posts
    67

    Re: Formula to Sum based on 2 criteria

    Oh My that was way to simple and i have been messing with this all day. To be honest with you i had not even thought of using a pivot table until you mentioned it, which would have saved me a lot of time here

    thank you very much.

    I really appreciate it

+ 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