How do I count occurences of data entered in a column??

[ssr]

Hi there can anyone help me out here.....

I am creating an app that has a column, say A, where "Yes"
or "No" can be selected from a list for each row of data entered. Therefore
column A will be populated
with an infinite number of "Yes" and "No" in no particular set order.

I firstly need to calculate how many times "Yes" occurs for column A and how
many times "No" occurs in that same column (A).

Once I have determined this I need to know the total amounts of times the
"Yes" + "No" has occured in column A.

After I have this information I then need to calculate percentages of the
"Yes" and "No" occurences which I think I can handle.

If it makes it easier I can send the file - and thanks in advance for any
help!

Simon

 

[RADO]

Simon,

no need for VBA programming here. Just use "Countif" function in excel. If
you need the whole column A, for example, use this:
=countif ("A:A","Yes")
=countif("A:A","No")

Best
RADO

 

[gocush]

Try:

=Countif("A:A","Yes")
=Countif("A:A","No")
=Countif("A:A","Yes")+Countif("A:A","No")