CountA will not count blank cells but will count cells which have a formula
returning "".
One way around this I suppose would be:
=COUNTIF(H1:H21,"Y")/(COUNTIF(H1:H21,"Y")+COUNTIF(H1:H21,"N"))

Hope this helps
Rowan

"danlinksman" wrote:

Sorry, one other question if you have time. How do I adjust for no
information in cells. Example H1..H21 is involved in the formula however I
have no data in H13..H21 and it is affecting the % effective. How can I get
the formula to ignore blank cells?

"danlinksman" wrote:

Outstanding.... It works perfect.

Thanks so much

"danlinksman" wrote:

I have a spreadsheet that list a planned completion date and then has an
actual completion date. I have a formula that places a Y or N depending if
production met the contractual due out date or not. What I want to do is
calculate my % effective based on the "Yes" and "No" criteria. Is there a
way?