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
 
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

Similar Threads

How to count responses? Possibly use COUNTIF? 4
Subtotals of repeating set of data 2
Analyzing survey results 6
Pivot Table HELP 2
Calculate Weighted Value 3
How can I count each possible response in a report to each questio 2
How can I give a numerical value to a radio button? 4
how to calculate man hours for different project ? 1

Top