Multiple answers calculation

Sneijders

New Member
Joined
Jun 19, 2021
Messages
2
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. MacOS
Hi all,

Let me explain what I'm trying to do:

I have a list of questions. Every answer to each question gets a score on several categories, for example:

Question 1:
Answer A (gives a score for category A: 1, gives a score for category B: 4, gives a score for category C: 7)
Answer B (gives a score for category A: 3, gives a score for category B: 2, gives a score for category C: 5)
Answer C (gives a score for category A: 2, gives a score for category B: 9, gives a score for category C: 6)

Every question is like this.
Every question has only one answer.

What I need / want, is to be able to see all possible combinations of the categories when people would fill this in.

So when someone answers A to all questions, what would the scores be per category.
If someone answers all B’s, what would be the score per category.
If someone answers 6B’s, 5A and 7 times a C, what would be the score per category.

I don’t need to see which combinations make which score, I just need a list of all the possible scores per category.

I hope this is possible with Excel, if not any other solution is welcome as well.

Best regards and a big thank you in advance!
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
51,748
Office Version
  1. 365
Platform
  1. Windows
Edit: I use Excel 2011 for MacOS.
That seems a little confusing. :confused:

1624102417146.png
 

Forum statistics

Threads
1,147,747
Messages
5,742,964
Members
423,769
Latest member
LongToast

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top