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.
1 Reply
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.
