vendredi 3 juillet 2015

ARRAY FORMULA with SUM IF and AND

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