Formula for the 4 most recent values related to a date

[Nebula2121]

Hi.

What is a formula to calculate the sum for the 4 most recent values based on a date value in a cell (E2)? The result that I am looking for is in (E5)

	A	B	C	D	E
1	Date	Value			Valuation Date
2	04/22/2018	2			07/22/2019
3	07/22/2018	5
4	10/22/2018	10			Result
5	01/22/2019	10			35
6	04/22/2019	5
7	07/22/2019	10

<tbody>
</tbody>

 

[Aryatect]

Hi, Are you looking for something like this:

Book1
	A	B	C	D	E
1	Date	Value			Valuation Date
2	4/22/2018	2			4/22/2019
3	7/22/2018	5
4	10/22/2018	10			Result
5	1/22/2019	10			30
6	4/22/2019	5
7	7/22/2019	10
Sheet3

Cell Formulas
Range	Formula
E5	=SUMPRODUCT(SUMIF($A$2:$A$7,LARGE(($A$2:$A$7<=$E$2)*(A2:A7),{1,2,3,4}),$B$2:$B$7))

 

[Nebula2121]

Thank you. This worked like a charm.

 

[Aryatect]

Glad could help and thanks for the feedback