=COUNTIF(A2:A20,"H")&" out of "&COUNTA(A2:A20)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dcham" wrote in
message ...

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:
http://www.excelforum.com/member.php...o&userid=33498
View this thread: http://www.excelforum.com/showthread...hreadid=532955