79582428

Date: 2025-04-19 13:16:21
Score: 1
Natty:
Report link

This also worked for me...

=SUM(MAP('Shot List'!A:A,'Shot List'!D:D,'Shot List'!H:H,LAMBDA(a,b,c,IF(a=B6,SUMPRODUCT(COUNTIF(a,B6),b*c)))))

Reasons:
  • Whitelisted phrase (-1): worked for me
  • Low length (1):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Dominic McAfee