How would I use an Excel formula to calculate the percentage of cells with a specific value?

I have a sheet full of "yes" and "no" and blank cells. I need to be able to find the percentageof yes cells.How would I use an Excel formula to calculate the percentage of cells with a specific value?
To find the # of Yes's as % of all the non-blank cells in the range (range is A1:Z1000):



=COUNTIF(A1:Z1000, "yes") / COUNTA(A1:Z1000)



To find the # of Yes's as % of all the cells in the range (including blank cells in the denominator):



=COUNTIF(A1:Z1000, "yes") / (COUNTA(A1:Z1000) + COUNTBLANK(A1:Z1000))



By the way, COUNTA(A1:A7, "Two") counts the non-blank cells in A1:A7, and adds one for the value "Two". It doesn't check how many of A1:A7 have the value "Two".



If you need more info, add more details or e-mail.

Cheers.

.How would I use an Excel formula to calculate the percentage of cells with a specific value?
You can use the Excel function "CountA"



CountA will count all the cells with a value in them.

example: =COUNTA(A2:A6)



CountA will also count all the cells with a specific value in them.

example: =COUNTA(A1:A7,"Two")



Take the totals, and divide for a percentage.How would I use an Excel formula to calculate the percentage of cells with a specific value?
Try doing a countif like this



=COUNTIF( *range of cells* ,"Yes")



then divide it by the total amount of cells that you want the average of. For example, if your Yes and No's were in the range of A1 to C3, the formula might look like this:



=COUNTIF(A1:C3,"Yes")/9