xlookup and Sum

[flashgordie]

Hello, I have an issue where I would like to look up a value in an array and have it return the sum of a quantity each time it fines the value.

In D2, I would like to place a formula that would lookup A2 in G2:G27 and return the sum of the corresponding quantities found in h2:H27. (side note- E2:15 simply equals the values that I manually calculated and that I think should be returned by the formula, and columns B and C bearing on this problem.

I believe a combination of xlookup and sum should get what I am looking for but I just can't seem to make it work.

Thank you for your Assistance!!!

xlookup example file.xlsx
	A	B	C	D	E	F	G	H
1	Id No.	Loctation	Factor	Function Here	should return		Id No.	Qty
2	12345	Bin 1	0.1		40		88888	8
3	12345	Bin 2	0.3		40		88888	12
4	23456	Bin 1	0.4		44		12345	1
5	23456	Bin 3	0.2		44		23456	2
6	23456	Bin 4	0.3		44		34567	3
7	34567	Bin 1	0.2		48		45678	4
8	34567	Bin 5	0.4		48		56789	5
9	45678	Bin 1	0.5		52		67890	6
10	45678	Bin 2	0.9		52		12345	7
11	56789	Bin 2	0.1		56		23456	8
12	56789	Bin 1	0.3		56		34567	9
13	56789	Bin 5	0.2		56		45678	10
14	67890	Bin 5	0.1		60		56789	11
15	88888	Bin 5	0.25		20		67890	12
16							12345	13
17							23456	14
18	In D2, I would like to place a formula that would lookup A2 in G2:G27 and						34567	15
19	return the sum of the corresponding quantities found in h2:H27.						45678	16
20	E2:15 equals the values that I think should be returned by the formula.						56789	17
21							67890	18
22							12345	19
23							23456	20
24							34567	21
25							45678	22
26							56789	23
27							67890	24
Sheet1

 

[Fluff]

How about

=SUMIFS(H:H,G:G,A2)

 

[flashgordie]

How about

=SUMIFS(H:H,G:G,A2)

Perfect. Simple. Thanks very much

 

[Fluff]

You're welcome & thanks for the feedback.