Prev: How do I set a pivot table to group quarterly reports by F/Y?
Next: Sorting Question
From: Rodman on 3 Mar 2010 11:38
Hello,

I am attempting to show the percentage complete (in a cell) using the
COUNTIF function.

I first formatted a cell (example A1) as a percent the I enter the following
formula in cell A1: =countif(b1:b12,"Completed")/countif(b1:b12,"*")

It returns the correct value in cell A1, however, I would like to add the
word "Completed" after the percent value.

Can Anyone Assist Me?

Thanks In Advance.
--
Rodman Veney
From: LarryP on 3 Mar 2010 12:18

Not a big Excel guru, but I should think if your formula is returning the
numeric value you want, tacking & "% Completed" at the end should
do it.


"Rodman" wrote:

> Hello,
>
> I am attempting to show the percentage complete (in a cell) using the
> COUNTIF function.
>
> I first formatted a cell (example A1) as a percent the I enter the following
> formula in cell A1: =countif(b1:b12,"Completed")/countif(b1:b12,"*")
>
> It returns the correct value in cell A1, however, I would like to add the
> word "Completed" after the percent value.
>
> Can Anyone Assist Me?
>
> Thanks In Advance.
> --
> Rodman Veney
From: Fred Smith on 3 Mar 2010 12:25
First, your formula can be simplified as follows:
=countif(b1:b12,"Completed")/counta(b1:b12)

Second to add "Completed", you do it with concatenation, as in:
=countif(b1:b12,"Completed")/counta(b1:b12)&" Completed"

However, Excel when you use concatenation, Excel formats numbers as General,
which isn't normally what is wanted.

To format your result, use the Text function as in:
=text(countif(b1:b12,"Completed")/counta(b1:b12),"0.00%")&" Completed"

Remember that you've now changed the data to text, and it can't be used in
calculations anymore.

Regards,
Fred






"Rodman" <Rodman(a)discussions.microsoft.com> wrote in message
news:7F68FC16-2741-4473-A4AB-CDC1C5BB21C9(a)microsoft.com...
> Hello,
>
> I am attempting to show the percentage complete (in a cell) using the
> COUNTIF function.
>
> I first formatted a cell (example A1) as a percent the I enter the
> following
> formula in cell A1: =countif(b1:b12,"Completed")/countif(b1:b12,"*")
>
> It returns the correct value in cell A1, however, I would like to add the
> word "Completed" after the percent value.
>
> Can Anyone Assist Me?
>
> Thanks In Advance.
> --
> Rodman Veney

From: Gary''s Student on 3 Mar 2010 12:32
=TEXT(COUNTIF(B1:B12,"Completed")/COUNTIF(B1:B12,"*"),"0.00%") & " Completed"

--
Gary''s Student - gsnu201001


"Rodman" wrote:

> Hello,
>
> I am attempting to show the percentage complete (in a cell) using the
> COUNTIF function.
>
> I first formatted a cell (example A1) as a percent the I enter the following
> formula in cell A1: =countif(b1:b12,"Completed")/countif(b1:b12,"*")
>
> It returns the correct value in cell A1, however, I would like to add the
> word "Completed" after the percent value.
>
> Can Anyone Assist Me?
>
> Thanks In Advance.
> --
> Rodman Veney
From: Daryl S on 3 Mar 2010 12:37
Rodman -

=TEXT(COUNTIF(B1:B12,"Completed")/COUNTIF(B1:B12,"*"),"0%") & " Completed"

--
Daryl S


"Rodman" wrote:

> Hello,
>
> I am attempting to show the percentage complete (in a cell) using the
> COUNTIF function.
>
> I first formatted a cell (example A1) as a percent the I enter the following
> formula in cell A1: =countif(b1:b12,"Completed")/countif(b1:b12,"*")
>
> It returns the correct value in cell A1, however, I would like to add the
> word "Completed" after the percent value.
>
> Can Anyone Assist Me?
>
> Thanks In Advance.
> --
> Rodman Veney
 |  Next  |  Last
Pages: 1 2
Prev: How do I set a pivot table to group quarterly reports by F/Y?
Next: Sorting Question