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