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

  • Thread starter Thread starter ssr
  • Start date Start date
S

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
 
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
 
Try:

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