Scoresheet creation for a trivia game

[Flexremmington]

I'm hoping the Xl2bb mini sheet below mostly explains things, because trying to fully explain what I'm doing would be a challenge for me!
For Q1, all who guessed "RED" (Bart, Moe, Lisa) should each get 4 points. All who guessed "ORANGE" (Lisa, Homer) should get 6. Yellow (Homer) gets 12, etc.
On Q2, Bart and Grandpa get 6, Moe 0, Homer 12, etc.
I've got all that figured, but I'm stuck on how to automatically add up how many points total that each player gets for the 5 questions.
The number of players may change each time (up to 12) and the numbers of correct answers for each question will also change for each question (up to 20 or so)
I hope this makes sense, and thanks ahead of time for any suggestions.

GROUP THINK SCORESHEET.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	# OF TEAMS	12
2		Q1	WHAT ARE THE COLORS OF THE RAINBOW
3	Team		RED	ORANGE	YELLOW	GREEN	BLUE	INDIGO	VIOLET	0	0	0	0	0	0	0	0	0	0	0	0	0
4			BART
5					HOMER
6				LISA
7						MARGE
8							MAGGIE
9			MOE
10								BARNEY
11									CARL
12			LENNIE
13							MR BURNS		GRANDPA
14				SMITHERS
15
16
17	GUSSES		3	2	1	1	2	1	2	0	0	0	0	0	0	0	0	0	0	0	0	0
18	POINTS		4	6	12	12	6	12	6	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
19
20
21
22		Q2	NAME ANIMALS
23	Team		COW	PIG	CHICKEN	MOOSE	DUCK	HORSE	BEAR	GATOR	MONKEY	ZEBRA	0	0	0	0	0	0	0	0	0	0
24
25							HOMER
26			MARGE							BART
27				LISA								CARL
28	MOE							MAGGIE
29
30											BARNEY
31					LENNIE	MR BURNS
32									SMITHERS
33										GRANDPA
34
35
36
37	GUSSES		1	1	1	1	1	1	1	2	1	1	0	0	0	0	0	0	0	0	0	0
38	POINTS		12	12	12	12	12	12	12	6	12	12	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
39
40
41
42		Q3	THINGS IN A GARAGE
43	Team		PLIERS	HAMMER	WRENCH	DRILL	GLUE	STAPLEGUN	SCREWDRIVER	PLIERS	PAINT	KNIFE	SAW	0	0	0	0	0	0	0	0	0
44	BART
45	HOMER
46	LISA
47	MARGE
48	MAGGIE
49	MOE
50	BARNEY
51	CARL
52	LENNIE
53	MR BURNS
54	SMITHERS
55	GRANDPA
56
57	GUSSES		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
58	POINTS		#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
59
60
61
62		Q4	PEOPLE IN THE BRADY BUNCH
63	Team		MARCIA	GREG	JAN	CAROL	MIKE	CINDY	ALICE	PETER	BOBBY	0	0	0	0	0	0	0	0	0	0	0
64	BART
65	HOMER
66	LISA
67	MARGE
68	MAGGIE
69	MOE
70	BARNEY
71	CARL
72	LENNIE
73	MR BURNS
74	SMITHERS
75	GRANDPA
76
77	GUSSES		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
78	POINTS		#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
79
80
81
82		Q5	SUPER HEROES AND VILLIANS
83	Team		SUPERMAN	BATMAN	GREEN LANTERN	FLASH	SPIDERMAN	IRONMAN	HULK	WONDERWOMAN	ROBIN	CATWOMAN	JOKER	MR FREEZE	0	0	0	0	0	0	0	0
84	BART
85	HOMER
86	LISA
87	MARGE
88	MAGGIE
89	MOE
90	BARNEY
91	CARL
92	LENNIE
93	MR BURNS
94	SMITHERS
95	GRANDPA
96
97	GUSSES		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
98	POINTS		#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
99
100
101
102
103
104
ROUND 1

Cell Formulas
Range	Formula
B1	B1	=COUNTIF(A4:AA15,"*")
A3	A3	=SCORE!A1
D3:V3,C2:C3	D3	='Q&A'!C3
C4,C12,C9	C4	=SCORE!A2
E5	E5	=SCORE!A3
D6,D14	D6	=SCORE!A4
F7	F7	=SCORE!A5
G8,G13	G8	=SCORE!A6
H10	H10	=SCORE!A8
I11	I11	=SCORE!A9
I13	I13	=SCORE!A13
C17:V17	C17	=COUNTIF(C4:C16,"*")
C18:V18,C98:V98,C78:V78,C58:V58,C38:V38	C18	=$B$1/C17
C22,C23:V23	C22	='Q&A'!B4
A23	A23	=SCORE!A1
G25	G25	=SCORE!A3
C26	C26	=SCORE!A5
J26	J26	=SCORE!A2
D27	D27	=SCORE!A4
L27	L27	=SCORE!A9
A28	A28	=SCORE!A7
H28	H28	=SCORE!A6
K30	K30	=SCORE!A8
E31	E31	=SCORE!A10
F31	F31	=SCORE!A11
I32	I32	=SCORE!A12
J33	J33	=SCORE!A13
C37:V37,C97:V97,C77:V77,C57:V57	C37	=COUNTIF(C24:C35,"*")
C42,C43:V43	C42	='Q&A'!B6
A43:A55	A43	=SCORE!$A1
C62,C63:V63	C62	='Q&A'!B8
A63:A75	A63	=SCORE!$A1
C82,C83:V83	C82	='Q&A'!B10
A83:A95	A83	=SCORE!A1

 

[Rijnsent]

Don't have the add-in installed, but what about this setup, have your points at the left and a list of correct answers to the right.
Formula:
D3: =IFERROR(MATCH(C3,$I$2:$K$2,0),0) -> checks if the answer is in the answer list, otherwise returns a 0
E3: =COUNTIF($C$3:$C$8,C3) -> checks how many times that answer was given
G3: =IF(D3>0,COUNTA($B$3:$B$8)/E3,0) -> if the answer was correct (greater than 0), calculate points

After that it should be easy to add up the scores per question...

THIS IS A1
Q1	NAME	ANSWER	ANSWER NR?	UNIQUE?	POINTS		CORRECT_ANSWERS	RED	GREEN	BLUE
	BART	RED	1​	2​	3
	MAGGIE	WHITE	0​	1​	-
	GRANDPA	GREEN	2​	1​	6
	HOMER	BLUE	3​	1​	6
	LISA	PURPLE	0​	1​	-
	MARGE	RED	1​	2​	3