Prev: Excell formula
Next: Deed a small data base
From: tobin.palmer on 21 Feb 2010 12:28
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?

From: T. Valko on 21 Feb 2010 12:57
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" <tobin.palmer(a)discussions.microsoft.com> wrote in message
news:FFE13B6A-8805-4E5B-A2A4-9FDF612900DE(a)microsoft.com...
> 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?
>


From: Lars-�ke Aspelin on 21 Feb 2010 13:00
On Sun, 21 Feb 2010 09:28:01 -0800, tobin.palmer
<tobin.palmer(a)discussions.microsoft.com> wrote:

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


Try this formula:

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

Hope this helps / Lars-�ke


 | 
Pages: 1
Prev: Excell formula
Next: Deed a small data base