How to define an Excel function to evaluate specified cells in a spreadsheet

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?

Recent Questions...