+ Reply to Thread
Results 1 to 4 of 4

Sumif or Sumifs with date range

  1. #1
    Registered User
    Join Date
    07-01-2015
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    12

    Sumif or Sumifs with date range

    Hi all,
    Just wanted to know if its possible to use sumif or sumifs with a date range.

    Basically, I want to lookup a name in a random list, count the days that they have, and then filter how many of those days fall within a date range.

    I've used sumif to lookup the name and count how many days they have in the entire list, but I can't for the life of me figure out how to then see how many of those days fall within specific dates.

    Any help would be appreciated.

    Ive attached a sample if that helps.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Sumif or Sumifs with date range

    Try this...
    =SUMIFS($C$4:$C$10,$B$4:$B$10,I4,$A$4:$A$10,">="&$I$3,$A$4:$A$10,"<="&$J$3)
    copied down

    Paul has 0 though, not 4
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    07-01-2015
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Sumif or Sumifs with date range

    Seems to have done the trick.

    Thanks

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Sumif or Sumifs with date range

    Happy to help and thanks for the feedback

+ 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] Sumifs with date criteria, but the range includes time with the date
    By Alphabex in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-08-2017, 12:08 AM
  2. SUMIFS - Across Date Range, Time Range, and by City
    By awilliams8976 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-09-2016, 06:51 PM
  3. [SOLVED] SUMIFS Across a Date Range
    By mphillips in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2015, 04:54 PM
  4. [SOLVED] SUMIF or SUMIFS to find text and date between from items in a table
    By Beefy1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-19-2014, 10:38 PM
  5. [SOLVED] Date range (SUMIFS)
    By shiser in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-21-2014, 12:44 PM
  6. [SOLVED] SUMIF/SUMIFS not working using Date fields as criteria
    By waynees in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2013, 09:24 AM
  7. Sumifs with date range - help please!
    By RuthieRu in forum Excel General
    Replies: 4
    Last Post: 08-14-2012, 05:50 AM

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