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.

Number of answers with "Agree"

=COUNTIF(D1:D26,"Agree")

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


If this post helps click Yes
---------------
Jacob Skaria


"AP" wrote:

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.