+ Reply to Thread
Results 1 to 4 of 4

SUMIFS dates are between or equal to specific dates

  1. #1
    Registered User
    Join Date
    04-30-2020
    Location
    Scotland
    MS-Off Ver
    Office 365
    Posts
    2

    Question SUMIFS dates are between or equal to specific dates

    Wondering if anyone can help me please?

    I am trying to get a formula to work and cannot figure out why it wont!

    I am looking to add together costs if the date in which the costs occurred fall within or are equal to specific dates.

    The formula I have detailed below is working for if the date of cost occurring is between the dates but I would also like it to pull through if it occurs on the same date

    =SUMIFS(Table2[Total Cost of Fogging],Table2[Date of Fogging],">"&Summary!B18,Table2[Date of Fogging],"<"&Summary!C18)

    I thought that by adding "=" before the ">" and after "<" this would solve the issue but it doesn't seem to work

    Sorry if this has been posted before, I'm new to this forum and would greatly appreciate the help!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,444

    Re: SUMIFS dates are between or equal to specific dates

    Did you try it like this?

    =SUMIFS(Table2[Total Cost of Fogging],Table2[Date of Fogging=Summary!B18,Table2[Date of Fogging],"<="&Summary!C18)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    04-30-2020
    Location
    Scotland
    MS-Off Ver
    Office 365
    Posts
    2

    Re: SUMIFS dates are between or equal to specific dates

    Yes I tried - =SUMIFS(Table2[Total Cost of Fogging],Table2[Date of Fogging],"=>"&Summary!B14,Table2[Date of Fogging],"<="&Summary!C14)

    but that didn't work. So I can get it to pick up the costs if it's between the dates but not equal to!

    Thank you for your help!

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,444

    Re: SUMIFS dates are between or equal to specific dates

    There are instructions at the top of the page explaining how to attach your sample workbook.

+ 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. Replies: 8
    Last Post: 07-20-2018, 11:52 AM
  2. [SOLVED] Returning specific dates, ignoring already returned dates
    By FP91 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-16-2018, 07:02 AM
  3. returning dates in between dates that matches a specific name
    By dpons in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-13-2015, 08:28 PM
  4. [SOLVED] Working with specific dates against Week Commencing dates
    By daveb86 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-11-2015, 05:36 AM
  5. Using sumifs to return data for specific dates
    By Mackay2m in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2015, 01:47 PM
  6. Pulling specific dates out of a list of dates
    By bohodgman in forum Excel General
    Replies: 3
    Last Post: 08-07-2013, 01:09 AM
  7. [SOLVED] Auto filling dates based on previously entered dates and averaging numbers if dates equal
    By grambograham in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-11-2012, 03:21 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