View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg
 
Posts: n/a
Default Matrix to single column

For Qty use this formula instead
=INDEX(array1,SUMPRODUCT((array_n=set1 R)*set_r),
SUMPRODUCT((array_n=set1 R)*set_c))