SUMIFSORT Assistance

[Anonnymouse]

Hello MrExcel,

I am wondering if there is a way if cell e has the same vin as any other in cell e it adds the price together and then sorts it in cell h with largest to smallest.

Thanks for the help!

	A	B	C	D	E	F	G	H	I	J	K
1​
2​		Order	Auction Price	Description	Doors	VIN			Total	Description	VIN
3​		12​	100​	BENZ	2​	5050​			350	BENZ	5050
4​		134​	50​	BENZ	2​	5050​			280	CHEVY	5020
5​		152​	60​	BENZ	2​	5060​			190	HONDA	5070
6​		167​	80​	FORD	4​	5010​			110	TOYOTA	5030
7​		176​	150​	CHEVY	4​	5020​			100	FORD	5010
8​		124​	20​	FORD	4​	5010​			60	BENZ	5060
9​		133​	40​	CHEVY	4​	5020​
10​		111​	90​	CHEVY	4​	5020​
11​		108​	110​	TOYOTA	4​	5030​
12​		197​	190​	HONDA	4​	5070​
13​		154​	200​	BENZ	2​	5050​

 

[Eric W]

Try:

Book1
	A	B	C	D	E	F	G	H	I	J	K
1
2		Order	Auction Price	Description	Doors	VIN			Total	Description	VIN
3		12	100	BENZ	2	5050			350	BENZ	5050
4		134	50	BENZ	2	5050			280	CHEVY	5020
5		152	60	BENZ	2	5060			190	HONDA	5070
6		167	80	FORD	4	5010			110	TOYOTA	5030
7		176	150	CHEVY	4	5020			100	FORD	5010
8		124	20	FORD	4	5010			60	BENZ	5060
9		133	40	CHEVY	4	5020
10		111	90	CHEVY	4	5020
11		108	110	TOYOTA	4	5030
12		197	190	HONDA	4	5070
13		154	200	BENZ	2	5050
Sheet1

Cell Formulas
Range	Formula
I3:K8	I3	=LET(u,UNIQUE(F3:F13),s,SUMIFS(C3:C13,F3:F13,u),SORT(CHOOSE({1,2,3},s,XLOOKUP(u,F3:F13,D3:F13,,0),u),,-1))
Dynamic array formulas.

 

[Anonnymouse]

Thank you, this worked!

 

[Eric W]

Happy to help! Thanks for the feedback.