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

  • Thread starter Thread starter tobin.palmer
  • Start date Start date
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?
 
Assuming the 4 is the result of the COUNTIF and 10 is the result of the
COUNT...

=COUNTIF(...)&" of "&COUNT(...)
 
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
 
Back
Top