Thread: In creating a COUNTIF and a COUNT to show as ie 4of10?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default In creating a COUNTIF and a COUNT to show as ie 4of10?
Assuming the 4 is the result of the COUNTIF and 10 is the result of the
COUNT...

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

--
Biff
Microsoft Excel MVP


"tobin.palmer" wrote in message
...
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?



Reply With QuoteReply With Quote