Nebula2121
New Member
- Joined
- Apr 1, 2016
- Messages
- 32
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)
<tbody>
</tbody>
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>