+ Reply to Thread
Results 1 to 4 of 4

Need to count no. of calls received based on multiple criteria

  1. #1
    Registered User
    Join Date
    12-09-2019
    Location
    Toronto, Canada
    MS-Off Ver
    Latest
    Posts
    2

    Need to count no. of calls received based on multiple criteria

    Hi professionals,

    I am trying to count my calls conversion data on excel. I have 2 sheets, sheet 1 with
    store locations and my KPIs (eg: Phone Calls, clicks etc) and sheet 2 with raw call data (number called from aka customers number, store location at which they called) I am looking to count 1 under phone calls on sheet 1 if a number calls on a location but if the same number calls on the same location for the second time it shouldn't be counted whereas if the same number calls on a different location it should be counted under that location. Could you please help with the steps and formulas required to achieve this goal. Please find a sample attachement under this thread.

    Thanks a lot!
    Attached Files Attached Files
    Last edited by reshiftabhay; 12-09-2019 at 03:10 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,705

    Re: Need to count no. of calls received based on multiple criteria

    It would help if you attached a sample Excel workbook. See the yellow banner at the top of the screen for details on how to do this.

    Pete

  3. #3
    Registered User
    Join Date
    12-09-2019
    Location
    Toronto, Canada
    MS-Off Ver
    Latest
    Posts
    2

    Re: Need to count no. of calls received based on multiple criteria

    Thanks for sharing, I have attached a sample doc to the thread.

    Abhay.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,705

    Re: Need to count no. of calls received based on multiple criteria

    Your file doesn't really explain what you want to do, or give any indication of what you would like the result to look like.

    Pete

+ 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. [SOLVED] Sum payments based on payment received range, count payments based on ID and package
    By STINSON in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-09-2016, 12:02 PM
  2. Replies: 4
    Last Post: 04-16-2015, 05:48 PM
  3. Replies: 6
    Last Post: 02-20-2015, 06:42 PM
  4. Count hours where calls are received.
    By LEXmono in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-29-2014, 07:33 AM
  5. Separate Calls Missed/Received
    By chrispulliam in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-20-2010, 10:58 PM
  6. Count Multiple Entries, Return Multiple Rows, Based On 3 Criteria
    By gtj_global in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-20-2008, 06:40 PM
  7. Counting calls received by time range by year
    By mmartens12 via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2006, 04:50 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