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

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

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/