mark cells containing a diff

[willwall]

Hello
I want excel to mark the cells that add up to a specific sum, in this case the sum is 1589. What is the best way to do this?

	A	B
1	Serienr	Belopp
2	1555	500
3	2555	100
4	3555	300
5	4555	-900
6	6555	321
7	7555	200
8	8555	418
9	9555	610
10	10555	40

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Joe4]

Use Solver.
See this tutorial here: https://www.youtube.com/watch?v=pBZbhvCqX44 (or the many other ones available on the internet).

 

[willwall]

Hello Joe

i looked at the video and it doesnt really work for me as i have too many variables. I have 1500 rows wih numbers. My examble above only shows 10....
Do ypu know another way that allows more variables?