How do I calculate a percentage of a column?

G

Geoff

I'm using Excel 2002 and have 3 columns. Column B is a series of Y's and N's
(Yes/No). At the bottom of the column, I would like to calculate the
percentage of Y's.

This sheet is a completeness report, so knowing how much work is complete in
percentage would be helpful.
Thanks
 
R

rajesh

Hi

Try this one:

=COUNTIF(A3:A11,"y")/(COUNTIF(A3:A11,"y")+COUNTIF(A3:A11,"n"))

Format the cell to %age

Regards
Rajesh
 
G

Geoff

Thanks! Worked perfectly

rajesh said:
Hi

Try this one:

=COUNTIF(A3:A11,"y")/(COUNTIF(A3:A11,"y")+COUNTIF(A3:A11,"n"))

Format the cell to %age

Regards
Rajesh
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I make column C a percentage of column B 3
Getting a percentage 6
Count Question 6
Count or sum help on query 1
How can I add up letters or symbols in excel 3
calculate a productivity percentage 1
Count the Y's in a filtered column that contains Y and N 1
Add only the cells after a particular number in the previous cell in the same column 1

Top