Search code examples
if-statementgoogle-sheetssumifsarray-formulas

ARRAYFORMULA with SUM, IF and AND

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?

Solution

  • Please try: 

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