TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
My question asked on excelforum and solved, including sample file (you must be registered to download):
The conditions are exact matches for the values in the table: =SUMPRODUCT(SUBTOTAL(109,OFFSET(INDEX(Table1[Qty],1),ROW(Table1[Qty])-MIN(ROW(Table1[Qty])),)),1-ISNUMBER(MATCH(Table1[Nm],H2:H6,0)))
The conditions are partial matches for the values in the table: =SUM(IF(SUBTOTAL(102,OFFSET(INDEX(Table1[Qty],1),ROW(Table1[Qty])-MIN(ROW(Table1[Qty])),)),IF(MMULT(0+ISNUMBER(SEARCH(TRANSPOSE(H2:H6),(Table1[Nm]))),ROW(H2:H6)^0)=0,Table1[Qty])))
|
|