I have table like this
☑ 667 No
☐ 667 No
☑ 667 Yes
And I want get total sum of numbers, but only when i checkbox checked AND when is state 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?
Aucun commentaire:
Enregistrer un commentaire