+ Reply to Thread
Results 1 to 5 of 5

Need to sum values whose date range covers a specific date

  1. #1
    Registered User
    Join Date
    05-27-2021
    Location
    Texas
    MS-Off Ver
    MS 365 for business: Excel Version 2014 (Build 13929.20386 Click-to-Run)
    Posts
    5

    Need to sum values whose date range covers a specific date

    See excel workbook attached. I need to come up with a formula for column E so that I do not have to manually Sum the corresponding values from the "Fixed Price Block Transactions" Table. For Example, in cell E45, Since the date is May-19, I need to sum up the "Block Size" Values from column H of the "Fixed Price Block Transactions" Table whose date range encompasses May of 2019. Please let me know if you can help with this.
    Attached Files Attached Files

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

    Re: Need to sum values whose date range covers a specific date

    Hi & welcome to the Board.
    How about in E41 filled down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-27-2021
    Location
    Texas
    MS-Off Ver
    MS 365 for business: Excel Version 2014 (Build 13929.20386 Click-to-Run)
    Posts
    5

    Re: Need to sum values whose date range covers a specific date

    Quote Originally Posted by Fluff13 View Post
    Hi & welcome to the Board.
    How about in E41 filled down
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Thank you for your quick response, this is exactly what I needed!

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

    Re: Need to sum values whose date range covers a specific date

    You're welcome & thanks for the feedback.

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Need to sum values whose date range covers a specific date

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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] trying VBA code to get specific data for unique IDs on specific date from date range
    By Roshan.Shakya in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-21-2019, 06:16 AM
  2. [SOLVED] I want to find the sum of values for a specific date from a range
    By Mr.Castle in forum Excel General
    Replies: 3
    Last Post: 03-03-2019, 02:55 PM
  3. Replies: 4
    Last Post: 03-21-2018, 09:25 AM
  4. [SOLVED] Count of specific values in a date range
    By bobbych in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-25-2015, 06:00 AM
  5. Count values in a row pertaining to a specific date range column
    By MattStolz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-23-2015, 03:21 PM
  6. Replies: 5
    Last Post: 05-04-2015, 04:36 PM
  7. min and max values w/in specific date range
    By Barz in forum Excel General
    Replies: 4
    Last Post: 09-30-2009, 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1