Data set:

```
A|B

1|a     
2|b     
3|c

```

Formula:

```
=SUMPRODUCT((B1:B3={"a";"b"}))

```

The sumproduct return NA there. I don't get why. I want it to return 2.

If I add c to the condition it correctly returns 3.

What am I my missing ?