How can I display the count function a "5 out of 15".

D

dcham

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?
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
T

Toppers

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

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
Click to expand...
 
B

Bob Phillips

Good point. Mine would ignore the blanks which is just as much not H as any
other letter <G>

Bob
 
Top