counting numbers of two rows with two conditions

[WhyExcelWhy?]

Dear smart people,

I have a problem with Excel. I'm doing a bachelor thesis on Entrepreneurial Attitudes and handed out questionaires. I'm now trying to work with them and I am a bit stuck. Help is highly appreciated. My goal is to compare the answers of students from my home university with those of my abroad university. I have a row with the university (translated into number 1 or 2), and I have a row with the answers ranging form 1 to 7.

Strongly disagree= 1
Moderatly disagree= 2
Slightly disagree = 3
neither agree or disagree= 4
Slightly agree= 5
Moderatly agree= 6
Strongly agree= 7

I now want to count for each of the 7 answers, how many answered form my home university and how many answered from my abroad university.

So if I want to do that for "Neither agree or disagree" for my home university I have two conditions: In the row of the "question" it needs to be a 4 and in the row of the "university" it needs to be a 1. And both need to be in the same column as well if I'm not mistaken.

With Kind Regards,
Why are you doing this to me Excel whyyyy?!

[BadlySpelledBuoy]

Sounds like a job for COUNTIFS.
Could you post some sample data (in a workbook)? Much easier to provide a solution if we can see your data layout.

BSB

[WhyExcelWhy?]

How can I post a worksheet in this forum?

[JohnTopley]

Click "Go Advanced" then scroll down to "Mange Attachments"

[WhyExcelWhy?]

Is it now attached. Not sure.

[BadlySpelledBuoy]

See attached for a COUNTIFS solution.

BSB

[JohnTopley]

Try

=COUNTIFS($A$2:$A$31,"=" &RIGHT(H$4)*1,$B$2:$B$31,"=" &ROWS($1:1))

Copy across and down to "Strongly agree"

For "Empty"

=COUNTIFS($A$2:$A$31,"="&RIGHT(H$4)*1,$B$2:$B$31,"=0")

SUM

=SUM(H5:H12)

[WhyExcelWhy?]

Thank you so much! You are really helping me out with this!

[WhyExcelWhy?]

Just one last question, the two data sets are not next to each other in the original dataset? Will I have problems with the Matrix because of that?

[BadlySpelledBuoy]

Shouldn't be a problem. Just refer to the correct ranges and all should work as expected.

BSB

[WhyExcelWhy?]

I tried it and it worked really well. Thank you so much!

[BadlySpelledBuoy]

Happy to help

Don't forget to mark the thread as SOLVED if you're happy you have a working solution.

Have a good evening.

BSB