Please see attached example.
Please note that I do not want to exchange the solution with SUMPRODUCT or SUMIF. I just want to learn why the hardcoded values inside my formula could not be replaced with Match function.
I just want to use Match function here to MATCH(D13,B1:L1,0) to return {2,5,7}.
I also tried using =--isnumber(MATCH(B1:L1,D13,0)) which will return '={0,1,0,0,1,0,1,0,0,0,0}
So i do not know how to get the positions of 1 1 1 from result of {0,1,0,0,1,0,1,0,0,0,0} and convert them into {2,5,7}
Thanks for your help.
Bookmarks