Setting up a flag count

%3CLINGO-SUB%20id%3D%22lingo-sub-2269732%22%20slang%3D%22en-US%22%3ESetting%20up%20a%20flag%20count%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2269732%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20column%20that%20has%20yes%20and%20no%2C%20how%20can%20I%20sum%20all%20the%20yes's%20and%20the%20no's%20to%20know%20how%20many%20of%20each%20I%20have.%20Sorry%20for%20the%20simple%20newbie%20question.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2269732%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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.