Solver Or VBA?

[jamiguel77]

Hello

How can I find out which Invoices add up to 609 in quantity AND also in Amount: $5,489,469, I manually found the sum of 609 but the amount does not match,

with SOLVER is it possible? yes yes how? or with VBA how, any code??

Thanks

1487.- md 6845.xlsx
	A	B	C
1	Invoice	Qty	Amount
2	90812798	18	166,130
3	90812799	3	27,550
4	90812800	18	204,360
5	90812801	8	61,230
6	90812802	10	98,640
7	90812803	15	145,080
8	90812804	27	241,020
9	90812805	22	106,815
10	90812895	11	96,590
11	90812896	9	77,120
12	90812897	6	53,010
13	90813114	5	43,705
14	90813115	32	299,190
15	90813116	7	60,040
16	90813117	4	38,600
17	90813118	8	90,030
18	90813119	10	50,400
19	90813523	40	351,855
20	90813524	21	167,907
21	90813525	7	70,250
22	90813526	4	41,830
23	90813835	10	90,555
24	90813836	15	130,205
25	90813837	7	59,010
26	90813838	8	70,930
27	90813839	4	39,950
28	90813840	10	84,886
29	90813841	4	58,700
30	90813842	9	77,385
31	90814011	48	458,837
32	90814012	20	173,540
33	90814013	1	3,770
34	90814014	7	65,820
35	90814015	3	25,130
36	90814016	6	76,050
37	90814017	21	201,620
38	90814018	21	182,299
39	90814702	6	52,560
40	90814703	3	28,810
41	90814704	23	202,824
42	90814705	4	38,430
43	90814706	14	72,100
44	90814707	18	153,797
45	90814708	4	59,245
46	90815155	2	15,800
47	90815156	11	98,310
48	90815157	2	20,180
49	90815158	4	33,955
50	90815159	31	283,120
51	90815750	1	5,480
52	90815751	35	334,440
53	90815752	6	49,800
54	90815753	9	87,360
55	90815755	6	31,650
56	90815756	9	81,670
57	90815757	20	179,430
Sheet

 

[HongRu]

try Pivot Table of Excel