Highlight/show cells if sum matches X

[KrsOne20]

I have a column with multiple values (thats my range). In this range I want to see which cells by sum match X. At the moment I use trial and error (manual selecting cells to see if they match X), but it is too time consuming. I tried searching on the internet, but I get the wrong results.

Example
[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]Product A
[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]Product C[/TD]
[TD]900[/TD]
[/TR]
</tbody>[/TABLE]

X = 1500. I need to find which cells match 1500, here it's product A + product B. What do I need to use, scenaria-analysis or what-iff model or does it need VBA? Thanks

 

[sheetspread]

Solver works:

Excel 2010
	A	B	C	D	E
1	Numbers
2	78	0			130
3	31	0
4	37	0
5	58	0
6	35	0
7	25	0
8	45	0
9	33	0
10	28	0
11	10	1
12	74	0
13	26	0
14	38	0
15	46	1
16	83	0
17	29	0
18	62	0
19	89	0
20	74	1
21	53	0
Sheet1

Cell Formulas
Range	Formula
E2	=SUMPRODUCT($A$2:$A$21,$B$2:$B$21)

 

[KrsOne20]

Awesome, thanks for the fast reply! I tried and it works. If I have more questions or run any problems I will ask them here

 

[brandonmcg]

I am fine with the easiest solution to match the loans to the total.