Results 1 to 5 of 5

Need to sum values whose date range covers a specific date

Threaded View

  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

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