I have an excel file with a few columns. The columns have yes/no answers. I would like to know the function to count all yes and no answers.
Thanks for helping an excel rookie.
I have an excel file with a few columns. The columns have yes/no answers. I would like to know the function to count all yes and no answers. Thanks for helping an excel rookie. 


Use So if you have a column C with values 1 through 5 as follows:
Formula would read:
This would output a result of 

