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

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

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

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


"ssr" wrote in message
...
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

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

Try:

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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/