Hi
I'm trying to modify the formula below, to calculate average % of the rows that match an input. So it should average the rows 6, 8, 10, 12 and 14, when the rows match my lookup values.
Right now, the formula does a sumproduct of two rows, adding them together if they matches my lookup value.=LET(s;B6:B15;t;IF(L6:P15="";0;L6:P15);m;MAP(D22:D24;LAMBDA(c;SUM((s=c)*t*DROP(IFNA(VSTACK(t;0);0);1))));m)
Hopefully the attached file helps explain it.
Thanks in advantage
Bookmarks