Look up Sum

[Mattsh]

Hi,

Is it possible to create a formula that adds a column of numbers to equal a pre defined number. so in the table below the numbers on the left are the values and the number in the next column is the total we are trying to find. so when you type a set of values in and then the sub total you are trying to find it highlights the right boxes.

402.32
383.57
469.07
507.40
423.52
	785.89

<tbody>
</tbody>

Not sure I have explained very well but hope someone undertsands

 

[Andrew Poulsom]

Look here:

http://www.tushar-mehta.com/excel/templates/match_values/index.html