Analyzing customer feedback is essential for understanding customer satisfaction and areas for improvement. In Excel, you can use the COUNTIF function to count the number of positive and negative feedback entries. Below is an example demonstrating how to use this function, along with an exercise for you to practice.
Example
Here’s an example of how the COUNTIF function works. You can see the embedded Excel sheet below to interact with the data.
| Customer | Feedback |
|---|---|
| 1 | Positive |
| 2 | Negative |
| 3 | Positive |
| 4 | Negative |
| 5 | Positive |
Exercise
Using the table below, count the number of positive and negative feedback entries using COUNTIF.
Solution
To count the number of positive and negative feedback entries:
- Using COUNTIF for "Positive" Feedback:
- Formula:
=COUNTIF(B2:B6, "Positive") - Result:
3(Customer 1, Customer 3, Customer 5)
- Formula:
- Using COUNTIF for "Negative" Feedback:
- Formula:
=COUNTIF(B2:B6, "Negative") - Result:
2(Customer 2, Customer 4)
- Formula:
Here's a table showing the results of the functions: