79363756

Date: 2025-01-17 05:56:08
Score: 1
Natty:
Report link

you can also use SUMPRODUCT() function to achieve this result.

=SUMPRODUCT((A2:C9="foo")*(D2:D9=1)*(E2:E9=2))

output = 2.0

Reasons:
  • Low length (1):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Utsav Sheta