yes and no?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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"
 
="Yes = " & COUNTIF(A:A,"Yes")

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
="''"&"YES "&COUNTIF(A:A,"yes")&"''"&" ''"&"NO "&COUNTIF(A:A,"no")&"''"

Vaya con Dios,
Chuck, CABGx3
 
Back
Top