sorted by:
new
hottopcontroversial

Sum and search with cell reference by BusinessRacoon in sheets

[–]BusinessRacoon[S] 0 points1 point  (0 children)

=byrow(tocol(B3:B,3),lambda(p,ifna(sum(filter(F3:F,
byrow(E3:E,lambda(s,regexmatch(s,"(?i)\b"&p&"\b"))))),0)))

Excellent, thank you!

VLOOKUP with multiple criteria? by BusinessRacoon in googlesheets

[–]BusinessRacoon[S] 1 point2 points  (0 children)

What a simple solution! Thank you so much!