79675637

Date: 2025-06-23 05:10:21
Score: 0.5
Natty:
Report link
## Sum of cells with YES as the corresponding value

You can also achieve the intended output using the formula below

Formula

=SUM(FILTER(D1:D, E1:E="YES"))

Sample Input

D E
2 Yes
8 No
10 Yes

Output

Output
15

References:

FILTER

SUM

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: 4thAnd1