Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
iulian93
 | Femeie
25 ani
Ilfov
cauta Barbat
27 - 68 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
TRaPModerator
Postari: 960
|
|
My question asked on excelforum and solved, including sample file (you must be registered to download):
https://www.excelforum.com/excel-formul ... table.html
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])))
|
|
| |
|
