In creating a COUNTIF and a COUNT to show as ie 4of10?

T

tobin.palmer

I'm realative new user of excel. And I'm tring to set up a file to
automatically countif and count. I understand how to do one individually, but
how can I get them to show as: 4 of 10 all in one cell?
 
T

T. Valko

Assuming the 4 is the result of the COUNTIF and 10 is the result of the
COUNT...

=COUNTIF(...)&" of "&COUNT(...)
 
L

Lars-Åke Aspelin

I'm realative new user of excel. And I'm tring to set up a file to
automatically countif and count. I understand how to do one individually, but
how can I get them to show as: 4 of 10 all in one cell?
Click to expand...


Try this formula:

=COUNTIF(...) & " of " & COUNT(...)

Hope this helps / Lars-Åke
 
Top