Counting

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

If I have a column that consists of "yeses" or "no's,"
how do I count the number of "yeses" in that column and
the number of no's in that column.
 
=COUNTIF(A1:A16,"YESES")

Assuming that A1:A16 is the column to count the "yeses"

=COUNTIF(B1:B16,"NO'S")

Assuming that B1:B16 is the column to count the "no's"

HTH,
Brenda
 
Assuming your data is in A1:A100, array enter into B1:C1
=COUNTIF(A1:A100,{"yes","no"})

Array enter means enter with Ctrl+Shift+Enter instead of just Enter.

The number of yes's will be returned to B1, the number of no's to C1.

Alan Beban
 
Back
Top