Displaying most recent number in a horizontal array

[des378]

Hi,

I have an array full of prices and 1 date column. I need to display the most recent value of each row's array that are all equal to today's date. I plan to sum all the numbers eventually.

Ex:

TODAY'S DATE: July 4th 2024

04-Jul	$14.00	$45.00		78.00​
18-May	$63.00	$86.00	$92.00​
04-Jul	$134.00	$34.00	$50.00
04-Jul	$25.00		​

Output:

78
50
25

(Summed up this would be 153)

Thanks in advance!

 

[Cubist]

You can try:

Book1
	A	B	C	D	E
1
2	4-Jul	$14.00	$ 45.00		$ 78.00
3	18-May	$63.00	$ 86.00	$ 92.00
4	4-Jul	$134.00	$ 34.00	$ 50.00
5	4-Jul	$25.00
6
7	Date	Most recent values	Sum
8	4-Jul	78	153
9		50
10		25
Sheet8

Cell Formulas
Range	Formula
B8:B10	B8	=BYROW(FILTER(B2:E5,A2:A5=A8),LAMBDA(r,XLOOKUP(TRUE,r<>0,r,,,-1)))
C8	C8	=SUM(B8#)
Dynamic array formulas.

 

[des378]

@Cubist this works perfectly! Thanks.

 

[Cubist]

You're welcome.