Many thanks to the all the users who tried to assist me, especially to CARACALLA for his solution. We all have many things still to learn, me included!
Many thanks to the all the users who tried to assist me, especially to CARACALLA for his solution. We all have many things still to learn, me included!
Correct file.
The previous one had a wrong structure
G14=SUMPRODUCT((ISNUMBER(MATCH($A$3:$K$10,$F14,0)))*(N(+$B$3:$L$10))*(INDEX($A$3:$K$10,,MATCH($E$13,$A$2:$K$2,0))=$E$14))
Copy down
I14=SUMPRODUCT((ISNUMBER(MATCH($A$3:$K$10,$F14,0)))*(N(+$B$3:$L$10))*(INDEX($A$3:$K$10,,MATCH($E$13,$A$2:$K$2,0))=$E$14)*($A$1:$K$1=I$13))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks