I have the following data on a spreadsheet (xlsx) (Excel 2011 14.6.4 for Mac):

```
No Yes Yes
No Yes Yes
No Yes Yes
```

I am trying to count the number of "Yes" values for just A1 and C1 skipping B1 (I can't just hide/delete the B column since it's used for other formulae).

I've tried the following formula:

```
=COUNTIF((A1,C1),"Yes")
```

but I'm getting a Value error with no info on what may have gone wrong. `A1:C1`

is inappropriate since I need to skip `B1`

. Any solutions?