Forum Discussion
Setting up a flag count
I have a column that has yes and no, how can I sum all the yes's and the no's to know how many of each I have. Sorry for the simple newbie question.
gsguyer To keep it simple, use COUNTIF like:
=COUNTIF(<range>, "Yes")
and
=COUNTIF(<range>, "No")Each one in their own cell. Replace <range> with a reference to the range where you want to count Yes or No.