Hi,
I would like to have sub totals of Marks against each category and name (
there are diffrent names). please help me with a general formula.

Thanks in advance
Jeevan


Sr. No Qtn No. Name Test No Subject Correct Option Marked Option
Marks sub total Category
1 Apoorva 4 2 -0.25 Analytical
5 Apoorva 3 4 -0.25 Analytical
9 Apoorva 1 4 -0.25 Analytical
13 Apoorva 4 4 1.00 Analytical
17 Apoorva 4 4 1.00 Analytical
4 Apoorva 4 4 1.00 Argument
8 Apoorva 4 4 1.00 Argument
12 Apoorva 2 0.00 Argument
16 Apoorva 3 3 1.00 Argument
20 Apoorva 4 0 0.00 Argument
2 Apoorva 4 4 1.00 Conceptual
6 Apoorva 4 4 1.00 Conceptual
10 Apoorva 4 4 1.00 Conceptual
14 Apoorva 2 2 1.00 Conceptual
18 Apoorva 1 1 1.00 5.00 Conceptual
3 Apoorva 3 2 -0.25 Skill
7 Apoorva 2 2 1.00 Skill
11 Apoorva 4 4 1.00 Skill
15 Apoorva 4 4 1.00 Skill
19 Apoorva 3 3 1.00 3.75 Skill