Multiply an array based on date value entered.

[AlInVegas2]

In one cell, I'm trying to get a product if from the array below. If I enter a date of 7/1/23, the result is the product of the Factor column for all dates that are less than or equal to the date entered.
In the case of 7/1/23, the result would be 1*7*3 or 21. In the case of 1/1/24, it would be 1*7*3*9 or 189.... attempting to use SumProduct( or Product(if commands with little success.

Date	Factor
09/01/2020	1
12/11/2021	7
06/04/2022	3
07/03/2023	9
01/02/2024	4
10/15/2024	6

 

[Fluff]

Duplicate to: Multiply an array based on date value entered.

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.