software

I have a column that we either enter “y” for yes or “n” for no to track
passing scores. Is there a way that I can average the yes’ and no’s from the
same column?

a combination of the countif and counta functions would do it for you

=COUNTIF(A1:A4,quot;yesquot;)/COUNTA(A1:A4)=COUNTIF(G:G,quot;yquot;)/COUNTA(G:G)

and format as a percentage

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;NKDoddquot; gt; wrote in message
news
gt; I have a column that we either enter quot;yquot; for yes or quot;nquot; for no to track
gt; passing scores. Is there a way that I can average the yes' and no's from
the
gt; same column?
Thank you very much. I knew I must have been trying to make this harder than
needed...

quot; wrote:

gt; a combination of the countif and counta functions would do it for you
gt;
gt; =COUNTIF(A1:A4,quot;yesquot;)/COUNTA(A1:A4)
gt;
gt;

On Thu, 27 Apr 2006 07:30:02 -0700, NKDodd
gt; wrote:

gt;I have a column that we either enter �y� for yes or �n� for no to track
gt;passing scores. Is there a way that I can average the yes� and no�s from the
gt;same column?One way.

With scores in A1:A20 and y/n in B1:B10

Average of the y cells
=SUMIF(B1:B20,quot;yquot;,A1:A20)/SUMPRODUCT((A1:A20lt;gt;quot;quot;)*(B1:B20=quot;yquot;))

Average of the n cells
just change the y's to n'sHTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Thanks for your help... it worked great

quot;Bob Phillipsquot; wrote:

gt; =COUNTIF(G:G,quot;yquot;)/COUNTA(G:G)
gt;
gt; and format as a percentage
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;NKDoddquot; gt; wrote in message
gt; news
gt; gt; I have a column that we either enter quot;yquot; for yes or quot;nquot; for no to track
gt; gt; passing scores. Is there a way that I can average the yes' and no's from
gt; the
gt; gt; same column?
gt;
gt;
gt;