+ Reply to Thread
Results 1 to 2 of 2

Sum if date falls between two dates

  1. #1
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,665

    Sum if date falls between two dates

    Hi,

    I have an excel formula which currently works where it looks at a date and then matches it to the appropriate column if the date falls between the start and end date.

    What I would like to do is improve on this formula to add in the following scenarios:
    1. All rows are summed (rows 7-9 on the example)
    2. If column G contains a “Yes” then bring in this element also taking into consideration the reversal date and amount


    Can anyone help please?

    Paul
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,665

    Re: Sum if date falls between two dates

    Hi,

    In cell H16 dragged down and accross I achieved it with this:
    =SUMIFS($F$7:$F$9,$E$7:$E$9,">="&H$14,$E$7:$E$9,"<="&H$15,$C$7:$C$9,$C16)+SUMIFS($I$7:$I$9,$H$7:$H$9,">="&H$14,$H$7:$H$9,"<="&H$15,$C$7:$C$9,$C16)

    However I am wondering if there is a cleaner way to achieve this?

+ 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. HELP: Return a value with a date that falls between two other dates
    By hionman in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 11-18-2014, 08:01 AM
  2. Replies: 12
    Last Post: 06-13-2014, 05:03 PM
  3. [SOLVED] How to compute if a date falls between two specified dates??
    By Swagata in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2012, 07:48 AM
  4. [SOLVED] Value with Corresponding Date if Falls Within Range of Dates
    By ebdmbfan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-26-2012, 09:14 AM
  5. [SOLVED] Return value in X if date in Y falls between two dates - Help!
    By nephilim3uk in forum Excel General
    Replies: 4
    Last Post: 07-08-2012, 10:13 AM
  6. returning a value if a date falls between two dates
    By chillangella in forum Excel General
    Replies: 3
    Last Post: 09-28-2009, 06:51 AM
  7. How to find if a date falls between 2 dates
    By JHL in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-19-2005, 01:50 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