How to count number of duplicates in a column and assign it to a variable

[ks100]

Column E has either the word "Yes" or "No" in it. It also has some blank cells.

How do I make a formula that in a seperate cell would say:

(Total number of "Yes" cells in column E) / (Total number of "Yes" and "No" cells in column E)


Thanks!

[Fotis1991]

Perhaps

Please Login or Register  to view this content.

[Pete_UK]

Try this:

=COUNTIF(E:E,"Yes") / COUNTA(E:E)

assuming those blank cells are truly empty.

Hope this helps.

Pete