+ Reply to Thread
Results 1 to 5 of 5

Sumifs Date Range not returning first date

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    07-10-2012
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    466

    Sumifs Date Range not returning first date

    Hello,

    I am using the following formula to return sums between a date range in column A & B.
    =SUMIFS($I$17:$I$100000,$A$17:$A$100000,">="&A3,$A$17:$A$100000,"<="&B3,$B$17:$B$100000,$C$2)

    The error I get is that it is not returning the first date even though I am using ">=".

    For example, date range in A:B is 08/1/21 & 08/31/21.

    If the date is 08/2/21 to 08/31/21 it will sum, but will not sum any dates that are 08/01/21.

    I appreciate any help figuring this one out.

    Thank you,
    Nick

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,431

    Re: Sumifs Date Range not returning first date

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,787

    Re: Sumifs Date Range not returning first date

    Do any of the dates in col A or in A3, B3 contain a time element as well as the date?

  4. #4
    Forum Contributor
    Join Date
    07-10-2012
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    466

    Re: Sumifs Date Range not returning first date

    Fluff13, smart! I changed the format to see if there was a time stamp, there was.

    Thank you!

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,787

    Re: Sumifs Date Range not returning first date

    Glad to help & 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. Week to date, month to date, year to date using SUMIFS
    By jaredf in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-23-2017, 01:51 PM
  2. [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
  3. Sumifs in between two date range
    By silambarasan.J in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-21-2016, 03:58 PM
  4. [SOLVED] SUMIFS Across a Date Range
    By mphillips in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2015, 04:54 PM
  5. [SOLVED] Returning a date from a range if date falls between two other dates
    By sdavison in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-25-2013, 03:59 AM
  6. Sumifs with date range - help please!
    By RuthieRu in forum Excel General
    Replies: 4
    Last Post: 08-14-2012, 05:50 AM
  7. [SOLVED] Using SUMIFS with a date range
    By millerman6566 in forum Excel General
    Replies: 3
    Last Post: 05-08-2012, 10:33 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