COUNTING YES'S AND NO'S IN A COLUMN


Posted by JIM on February 05, 2002 7:14 AM

Can anyone tell me how to count the number of yes's and no's in a column. Thanks for the help!!



Posted by Juan Pablo G. on February 05, 2002 7:15 AM

=COUNTIF(A:A,"YES") and =COUNTIF(A:A,"NO")