I am trying to create the following formula

```
=SUM(IF(AND(K3:K138="Tekken",L3:L138="American Football"),1))
```

However, it always seems to result in zero, even where a single row would have both values for Tekken and American Football. I have gotten the simpler formula to work...

```
=SUM(IF(K3:K138="Tekken",1))
```

This formula works fine and counts the rows that have values for Tekken. I am wondering why this works, but the former results in a value of 0. I have rows that have both values and should represent a 1.

Does there have to be special use of AND when dealing with Arrays?

`AND(K3:K138="Tekken",L3:L138="American Football")`

is TRUE only when all values in all rows are the designated text values. In array formulas you can simulate AND with * so this version will work -`=SUM(IF((K3:K138="Tekken")*(L3:L138="American Football"),1))`

– barry houdini May 18 '13 at 10:08`=COUNTIF(K3:K138,"Tekken")`

– barry houdini May 18 '13 at 10:10