Counting the numbers

[Dexir]

Greetings All,
i have this sheet, i want to make the summary of the question & viva. i want the result in L column like highlighted in Yellow color. please help.

 

[awoohaw]

I am not sure what your question is. What is "viva"? But, if you want to calculate the yellow, try this, in the light red:
Items 10 through 15 have no result because your sample data does not extend that far. But, I'm just guessing at that point.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1					Q
2			5	4	3	2	1
3	1			x					1	4		4
4	2				x				2	3		3
5	3		x						4	0		0
6	4								6	3		3
7	5								8	0		0
8	6				x				10	1
9	7								12	4
10	8								14	3
11									15	0
Sheet1

Cell Formulas
Range	Formula
L3:L11	L3	=IFERROR(IF(COUNTIF(INDEX($C$3:$G$10,I3,0),"x")=0,0, INDEX($C$2:$G$2,SUM((INDEX($C$3:$G$10,I3,0)="x")*(COLUMN(L2:P2)-11)))),"")