count cells quantity with a special contained word and calculate the percentage

119 views Asked by At

How can I count cells quantity with a special contained word and calculate the percentage in excel?

For example I have a survey database about a product. the feedbacks are "Good, Not Bad, Bad".

I want to count the quantity of each type of feedbacks and finally calculate the percentages and draw a diagram of that.

1

There are 1 answers

0
Axel Richter On BEST ANSWER

This should be achievable simply with COUNTIF. https://support.office.com/en-us/article/COUNTIF-function-e0de10c6-f885-4e71-abb4-1f464816df34

enter image description here

Formulas:

E1

=SUM($E$2:$E$10000)

E2 downwards as needed:

=COUNTIF($B:$B,$D2)

F1 downwards as needed:

=$E1/$E$1