Average calculation if cell contain certain text

[bmarroush]

Dear

How it is possible to have formula set in a cell where i need to calculate an Average of cells containing certain text.

For e.g. I have cells from 1 to 10 some contains "Prevent" and some contains "Detect"

I want to have and Average percentage for Prevent only and Detect only

Thanks

 

[arthurbr]

Perhaps = countif(a1:a100,"Prevent")/COUNTA(a1:a100)
Adapt ranges to your needs
The same for other text
Format as percentage