Results 1 to 4 of 4

Thread: Sum number of calls within a specific time frame

  1. #1
    Seeker t83357's Avatar
    Join Date
    Aug 2013
    Location
    West hartford, CT
    Posts
    5
    Articles
    0

    Sum number of calls within a specific time frame



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have created a pivot table which properly display the time of day and the number of calls at that time. (There happens to be only one call per minute but in theory there can be multiple calls made in the same minute). I have tried to sum the calls by hour using countif and a variety of other things. Any help would be appreciated! Below is an image of what I am trying to calculate and the sample excel sheet is also attached.

    Click image for larger version. 

Name:	2013-12-10_1650.png 
Views:	14 
Size:	37.3 KB 
ID:	1879
    Attached Files Attached Files

  2. #2
    Excel 2010, Table, PivotTable, PowerPivot, PivotChart
    With and without formulas.
    http://www.mediafire.com/view/gi7ge2...12_09_13a.xlsx

  3. #3
    Seeker t83357's Avatar
    Join Date
    Aug 2013
    Location
    West hartford, CT
    Posts
    5
    Articles
    0
    It looks good but just a question. I don't see any formulas and did you change the number of calls from 1 to random numbers up to 5 just for display purposes? It looks great but I don't follow it without seeing the formulas.

  4. #4
    The regular PivotTable does not use formulas,
    the PowerPivot PT uses DAX formulas.
    PowerPivot is more flexible and more powerful.
    Recommended literature:
    PowerPivot for Excel 2010 by Russo and Ferrari.
    I introduced random numbers for test purposes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •