Adding percentage to a formula with text & countif

Hi guys,

Using google sheets.

I have this text:

="Number of members left to submit entries: " & COUNTIF(D8:D47, "1") & " out of 40"

I want to add on to this formula.... what the value of COUNTIF(D8:D47, "1") out of 40 people is in a percentage. so it should read

="Number of members left to submit entries: " & COUNTIF(D8:D47, "1") & " out of 40" (90%) cana yone guide me if this is possible?

thankyu

You could use:

="Number of members left to submit entries: " & COUNTIF(D8:D47, "1") & " out of 40 ("&TEXT(COUNTIF(D8:D47, "1")/40,"0%")&")"

thank you!