Apr 13 2021 02:27 AM
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.
Apr 13 2021 02:57 AM
@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.