software

I use the count function to total the number of ‘H’s = (Hired) employees
in my spreadsheet. I would like the result to show as 5 out of 15. Is
this possible?--
dcham
------------------------------------------------------------------------
dcham's Profile: www.excelforum.com/member.php...oamp;userid=33498
View this thread: www.excelforum.com/showthread...hreadid=532955=COUNTIF(A2:A20,quot;Hquot;)amp;quot; out of quot;amp;COUNTA(A2:A20)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;dchamquot; gt; wrote in
message ...
gt;
gt; I use the count function to total the number of 'H's = (Hired) employees
gt; in my spreadsheet. I would like the result to show as 5 out of 15. Is
gt; this possible?
gt;
gt;
gt; --
gt; dcham
gt; ------------------------------------------------------------------------
gt; dcham's Profile:
www.excelforum.com/member.php...oamp;userid=33498
gt; View this thread: www.excelforum.com/showthread...hreadid=532955
gt;


=COUNTIF(A2:A20,quot;Hquot;)amp;quot; out of quot;amp; ROWS(A2:A20)

quot;Bob Phillipsquot; wrote:

gt; =COUNTIF(A2:A20,quot;Hquot;)amp;quot; out of quot;amp;COUNTA(A2:A20)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;dchamquot; gt; wrote in
gt; message ...
gt; gt;
gt; gt; I use the count function to total the number of 'H's = (Hired) employees
gt; gt; in my spreadsheet. I would like the result to show as 5 out of 15. Is
gt; gt; this possible?
gt; gt;
gt; gt;
gt; gt; --
gt; gt; dcham
gt; gt; ------------------------------------------------------------------------
gt; gt; dcham's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33498
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=532955
gt; gt;
gt;
gt;
gt;

Good point. Mine would ignore the blanks which is just as much not H as any
other letter lt;Ggt;

Bob

quot;Toppersquot; gt; wrote in message
...
gt;
gt;
gt; =COUNTIF(A2:A20,quot;Hquot;)amp;quot; out of quot;amp; ROWS(A2:A20)
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; =COUNTIF(A2:A20,quot;Hquot;)amp;quot; out of quot;amp;COUNTA(A2:A20)
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;dchamquot; gt; wrote in
gt; gt; message ...
gt; gt; gt;
gt; gt; gt; I use the count function to total the number of 'H's = (Hired)
employees
gt; gt; gt; in my spreadsheet. I would like the result to show as 5 out of 15.
Is
gt; gt; gt; this possible?
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; dcham
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; gt; dcham's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=33498
gt; gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=532955
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;