How can I calculate the numbers?

A

AP

Hi all

I'm busy capturing a staff survey.

I need to calculate the number of times the staff members answered "Agree,
Disagree, etc" to questions 1 - 26 from a specific area.

Let's say:

Column A: Question No
Column B: Question
Column C: Region
Column D: Answer

A B C
D
1 I am very satisfied with my job. Eastern Cape Agree
5 Staff are encouraged to develop. Gauteng Disagree
8 Staff are paid fairly for the work. Western Cape
Strongly Disagree
7 Management make a real effort. KZN Agree
1 I am very satisfied with my job. Eastern Cape Agree

Please help, I'm really stuck with this one.
 
J

Jacob Skaria

Number of answers with "Agree"

=COUNTIF(D1:D26,"Agree")

with disagree
=COUNTIF(D1:D26,"Disagree")


If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top