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:
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?