Xlookup to SUM first and last values in a list with multiple entries

[Zakky]

Hi, I am trying to sum the first and last values in a list where there are multiple entries of the same product. The formula works well for >1 entry, but it fails on a single entry. For some strange reason, it doubles the value of the single entry. Not quite sure how to fix it using XLookup. Your help would be greatly appreciated. Thank you.

 

[Cubist]

Book1
	A	B	C	D	E	F
1
2	Product	Sales		Product	Sales
3	Apples	1		Apples	8
4	Onions	2		Onions	2
5	Carrots	3		Carrots	11
6	Apples	4		Grapes	5
7	Grapes	5		Oranges	7
8	Oranges	6		Bananas	12
9	Apples	7
10	Carrots	8
11	Oranges	9
12	Bananas	10
13	Bananas	11
14	Bananas	2
15	Oranges	1
16
Sheet1

Cell Formulas
Range	Formula
D3:D8	D3	=UNIQUE(A3:A15)
E3:E8	E3	=BYROW(D3#,LAMBDA(r,LET(f,FILTER(B3:B15,r=A3:A15),IF(ROWS(f)=1,f,TAKE(f,1)+TAKE(f,-1)))))
Dynamic array formulas.

 

[Zakky]

Cubist, Thank you for the prompt reply. WOW! There was a lot more work to do than i thought. As always, your solution works like a dream. Once again, thank you for helping. Have a great day!