Can somebody explain this formula step by step in details
View attachment 98625
Result Formula
View attachment 98625
Result Formula
=LET(a,Companies,b,ROWS(a),m,MAKEARRAY(b,2,LAMBDA(r,c,SUM(INDEX(C5:Z9,SEQUENCE(b),SEQUENCE(,24))*(C4:Z4=INDEX(C22:D22,c))*(a=INDEX(a,r))))),t,HSTACK(a,m),FILTER(t,INDEX(t,,3))) |