Results 1 to 3 of 3

Formula to Sum based on 2 criteria

Threaded 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

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