find sum in list of of numbers
If your list only has up to 9 values, the following worksheet functions
will do the trick.
1. In range A1:A9 enter the list of amounts
2. Enter you're the figure you need to reconcile in A11
3. In the range of cells A15:I525,
enter the formula "=VALUE(MID(DEC2BIN(ROW()-14,9),COLUMN(),1))"
4. In the range J15:J525,
enter the array formula "{=MMULT(A15:I525,A1:A9)}"
5. In the range B1:B9,
enter the formula "=OFFSET($A$14,MATCH($A$11,$J$15:$J$525,0),ROW ()-1)"
Amounts that reconcile to the figure in A11 will have a 1 next to them
in column B
|