Soni123456
New Member
- Joined
- Jan 12, 2017
- Messages
- 5
Hi all,
Was wondering if someone could help me with this. I have a list of participants all belonging to different departments and they have all answered a number of items using the ratings "Strongly agree, Agree, No opinion, Disagree, Strongly disagree". I want to be able to count the number of agrees and strongly agrees for people belonging to only one department (i.e. HR).
A B C D E F
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> [TABLE="width: 0"]
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"></colgroup><tbody>[TR]
[TD]Department[/TD]
[TD]Q1[/TD]
[TD]Q2[/TD]
[TD]Q3[/TD]
[TD]Q4[/TD]
[TD]Q5[/TD]
[/TR]
[TR]
[TD]HR[/TD]
[TD]Agree[/TD]
[TD]Strongly Agree[/TD]
[TD]Agree[/TD]
[TD]Disagree[/TD]
[TD]Strongly Agree[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]No opinion/ Not applicable[/TD]
[TD]Disagree[/TD]
[TD]No opinion/ Not applicable[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[/TR]
[TR]
[TD]IT[/TD]
[TD]Disagree[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[TD]Disagree[/TD]
[/TR]
[TR]
[TD]IT[/TD]
[TD]Agree[/TD]
[TD]Strongly Agree[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[TD]Strongly Agree[/TD]
[/TR]
[TR]
[TD]IT[/TD]
[TD]No opinion/ Not applicable[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[TD]No opinion/ Not applicable[/TD]
[TD]Agree[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Agree[/TD]
[TD]Strongly Agree[/TD]
[TD]Strongly Agree[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[/TR]
[TR]
[TD]HR[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[TD]Disagree[/TD]
[TD]Agree[/TD]
[TD]Disagree[/TD]
[/TR]
[TR]
[TD]HR[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[TD]Disagree[/TD]
[TD]Disagree[/TD]
[TD]Disagree[/TD]
[/TR]
[TR]
[TD]HR[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[TD]Disagree[/TD]
[TD]Disagree[/TD]
[TD]Disagree[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Agree[/TD]
[TD]Strongly Agree[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[TD]Strongly Agree[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]No opinion/ Not applicable[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[TD]No opinion/ Not applicable[/TD]
[TD]Agree[/TD]
[/TR]
</tbody>[/TABLE]
I have used this formula but it doesn't seem to work
=if(A2:A12="HR",(countifs(B2:F12,"Strongly agree",B2:F12,"Agree"),""))
Thank you SO much in advance
Was wondering if someone could help me with this. I have a list of participants all belonging to different departments and they have all answered a number of items using the ratings "Strongly agree, Agree, No opinion, Disagree, Strongly disagree". I want to be able to count the number of agrees and strongly agrees for people belonging to only one department (i.e. HR).
A B C D E F
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> [TABLE="width: 0"]
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"></colgroup><tbody>[TR]
[TD]Department[/TD]
[TD]Q1[/TD]
[TD]Q2[/TD]
[TD]Q3[/TD]
[TD]Q4[/TD]
[TD]Q5[/TD]
[/TR]
[TR]
[TD]HR[/TD]
[TD]Agree[/TD]
[TD]Strongly Agree[/TD]
[TD]Agree[/TD]
[TD]Disagree[/TD]
[TD]Strongly Agree[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]No opinion/ Not applicable[/TD]
[TD]Disagree[/TD]
[TD]No opinion/ Not applicable[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[/TR]
[TR]
[TD]IT[/TD]
[TD]Disagree[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[TD]Disagree[/TD]
[/TR]
[TR]
[TD]IT[/TD]
[TD]Agree[/TD]
[TD]Strongly Agree[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[TD]Strongly Agree[/TD]
[/TR]
[TR]
[TD]IT[/TD]
[TD]No opinion/ Not applicable[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[TD]No opinion/ Not applicable[/TD]
[TD]Agree[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Agree[/TD]
[TD]Strongly Agree[/TD]
[TD]Strongly Agree[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[/TR]
[TR]
[TD]HR[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[TD]Disagree[/TD]
[TD]Agree[/TD]
[TD]Disagree[/TD]
[/TR]
[TR]
[TD]HR[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[TD]Disagree[/TD]
[TD]Disagree[/TD]
[TD]Disagree[/TD]
[/TR]
[TR]
[TD]HR[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[TD]Disagree[/TD]
[TD]Disagree[/TD]
[TD]Disagree[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Agree[/TD]
[TD]Strongly Agree[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[TD]Strongly Agree[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]No opinion/ Not applicable[/TD]
[TD]Agree[/TD]
[TD]Agree[/TD]
[TD]No opinion/ Not applicable[/TD]
[TD]Agree[/TD]
[/TR]
</tbody>[/TABLE]
I have used this formula but it doesn't seem to work
=if(A2:A12="HR",(countifs(B2:F12,"Strongly agree",B2:F12,"Agree"),""))
Thank you SO much in advance