yes and no?

[tapley]

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)

"tapley" <[email protected]> wrote in message
news:[email protected]...
> 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"

[CLR]

="''"&"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"