79702212

Date: 2025-07-15 14:19:01
Score: 3
Natty:
Report link

Ok, I found a way now, but not with SEQUENCE. I used SUM and MAP instead (RESULT =68.000 in my case

=SUM(MAP(B1:B17;H1:H17;LAMBDA(a;b;a*CHOOSE(MATCH(b;K$1:M$1;0);K$3;L$3;M$3))))

enter image description here

Reasons:
  • Probably link only (1):
  • Low length (1):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: iCBM