+ Reply to Thread
Results 1 to 5 of 5

formula to sum between two dates

  1. 04-07-2015, 01:39 PM #1
    felixpanganiban
    felixpanganiban is offline
    Registered User
    Join Date
    10-02-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    86

    formula to sum between two dates

    please help me to sum between two dates using formula:
    sample sheet.xlsx
    👍
    Reply With QuoteRegister To Reply
  2. 04-07-2015, 01:42 PM #2
    popipipo
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: formula to sum between two dates

    =SUMPRODUCT((D6:D12)*(C6:C12>=C15)*(C6:C12<=D15))
    Try this
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong
    Reply With QuoteRegister To Reply
  3. 04-07-2015, 01:43 PM #3
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: formula to sum between two dates

    =SUMIFS(D$6:D$12,C$6:C$12,">="&C15,C$6:C$12,"<="&D15)
    try this
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  4. 04-07-2015, 02:02 PM #4
    felixpanganiban
    felixpanganiban is offline
    Registered User
    Join Date
    10-02-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    86

    Re: formula to sum between two dates

    thank you very much. popipipo.. its great!!
    Reply With QuoteRegister To Reply
  5. 04-07-2015, 02:04 PM #5
    felixpanganiban
    felixpanganiban is offline
    Registered User
    Join Date
    10-02-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    86

    Re: formula to sum between two dates

    also great nflsales. thank you to all of you.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Creating a formula to populate range of cells between dates based on start and end dates
    By Rainmain82 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-20-2014, 07:42 PM
  2. [SOLVED] Creating a formula to populate range of cells between dates based on start and end dates
    By Rainmain82 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-18-2014, 07:55 AM
  3. Formula to highlight dates on a calendar for multiple people scheduled for school dates
    By meltyface81 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-14-2014, 02:01 AM
  4. Conditional Formatting Formula for hightlighting past dates, upcoming dates, and no blanks
    By cataustin1 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-04-2014, 08:28 PM
  5. Check dates in range either same dates or different dates by formula
    By breadwinner in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-12-2013, 07:42 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1