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)


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Date[/TD]
[TD]Value[/TD]
[TD][/TD]
[TD][/TD]
[TD]Valuation Date[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]04/22/2018[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]07/22/2019[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]07/22/2018[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]10/22/2018[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]01/22/2019[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD]35[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]04/22/2019[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]07/22/2019[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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