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 to use/create code in MS Word to calculate age? 0
How do I make column C a percentage of column B 3
Getting a percentage 3
Setting column width in a table with a macro is not working 0
Calculate the median value before a specified list 0
Count or sum help on query 1
MS Project. Real progress of the project, % complete 1
Format column widths from one table to a separate table on same page 1

Top