Results 1 to 5 of 5

SUMIFS - Across Date Range, Time Range, and by City

Threaded View

  1. #1
    Registered User
    Join Date
    08-09-2016
    Location
    USA
    MS-Off Ver
    MS Office 2010
    Posts
    2

    SUMIFS - Across Date Range, Time Range, and by City

    Hello All,

    I'm trying to see if it's possible to use the Sumifs formula to add up the number of support tickets received for a specific city, across a date range, and broken down by hour.

    Current Formula (see attach spreadsheet and the Atlanta section of overview):
    =SUMIFS('Raw Data'!$E$4:$E$967,'Raw Data'!$A$4:$A$967,"<="&$C$4,'Raw Data'!$A$4:$A$967,">="&$C$3,'Raw Data'!$B$4:$B$967,"="&$C6)

    This isn't giving me any results. I'm thinking that I'm using the wrong formula or I am forgetting a parameter. Is there any help that you guys could provide?

    Thank you!
    - Adam
    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. sumifs for time range
    By PLD60 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-06-2014, 04:33 AM
  2. [SOLVED] Date range (SUMIFS)
    By shiser in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-21-2014, 12:44 PM
  3. [SOLVED] SUMIFS for Date Range
    By rlb278 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-23-2012, 03:26 PM
  4. [SOLVED] sumifs within date range
    By freud1 in forum Excel General
    Replies: 2
    Last Post: 08-22-2012, 04:56 PM
  5. Sumifs with date range - help please!
    By RuthieRu in forum Excel General
    Replies: 4
    Last Post: 08-14-2012, 05:50 AM
  6. [SOLVED] Using SUMIFS with a date range
    By millerman6566 in forum Excel General
    Replies: 3
    Last Post: 05-08-2012, 10:33 AM
  7. Formula help with SUMIFs and time range
    By Maricha in forum Excel General
    Replies: 9
    Last Post: 08-08-2011, 02:52 PM

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