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"

Try

=COUNTIF(a:a,"No")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=544587

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"tapley" wrote in message
...
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")&"''"&" ''"&"NO "&COUNTIF(A:A,"no")&"''"

Vaya con Dios,
Chuck, CABGx3



"tapley" wrote:

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"