ARRAYFORMULA with SUM, IF and AND

Question

I have a table like this:

☑   667     No
☐   667     No
☑   667     Yes

and want to sum the numbers when the checkbox is checked and the state is YES.

I tried something like this,

=ARRAYFORMULA(SUM(IF(AND(A2:A<>"☐",C1:C="Yes"),B1:B)))

but it is not working.

Anyone can help me?

Answer 1

Please try:

=sumifs(B:B,A:A,"☑",C:C,"YES")