yes and no?

[Guest]

I have one column with yes or no in each box. Is there a formula that will
count the number of yeses and put it in a box for me? so I get "YES 203" "NO
42"

 

[daddylonglegs]

Try

=COUNTIF(a:a,"No"

 

[Bob Phillips]

="Yes = " & COUNTIF(A:A,"Yes")

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[Guest]

="''"&"YES "&COUNTIF(A:A,"yes")&"''"&" ''"&"NO "&COUNTIF(A:A,"no")&"''"

Vaya con Dios,
Chuck, CABGx3