Hi

Use a Pivot Table.

Look at this site to get started:

http://contextures.com/CreatePivotTable.html

Regards,
Per



On 18 Apr., 06:58, "Vinay Vasu" wrote:
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