View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel,microsoft.public.excel.newusers
BrianP[_2_] BrianP[_2_] is offline
external usenet poster
 
Posts: 1
Default 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