How to sum a row when the sum of a different row equals a certain value, and only between two dates

[drmcbiz]

Hi all,

Sorry for the confusing title. Having problems figuring this out elegantly. I've got a huge workbook so I was hoping to solve this in one cell (as I need to solve this thousands of times in the one workbook and having multiple rows of formula to figure out the answer keeps making my Excel crash!).

What I'm trying to do is this:

Between the dates of 2/1/23 and 9/1/23 I want to sum up the profit made (column D) on the first $500 of notes exercised (column C). The answer here should be $20 (highlighted in green).

Thanks!

 

[Peter_SSs]

OK, thanks for the additional information.

BTW, did you try & compare calculation time using the user-defined function from post #15?