View original (French)

If Excel cells contain such text, calculate percentage.

Solved
Bonzo -  
 Bonzo -
Hello,

I have an Excel file with several columns, one of which indicates the activity sector of the product users. One of these sectors is "general."
This column has 100 rows.

I would like to find a formula that automatically calculates the percentage of "general" users in this column and displays it in another cell of my choice (let's say cell J12).

Thank you in advance for your help.

Configuration: Windows 7 / Chrome 48.0.2564.97

2 réponses

Réponse 1 / 2
diablo13800 Posted messages 3469 Registration date   Status Membre Last intervention   1 872
 
Hello,

You can use this formula to calculate the percentage of people whose field is general (to be adapted and may not be the most optimal)
just put it in the cell you want:
=COUNTIF(B:B,"general")/COUNTA(B:B) *100
5
Bonzo
 
Same, the formula works perfectly.

Thank you very much!
0