Highest value and total value

[apgmin]

Hello All,
Can any one please help me with this.

Column J has the list of all students names

In Column B we have to select the students name as it is data validation, list of J1 to J1000
Column C ( course name ) is the V look up so it gets auto populated
column D we mention the semester number for which he has paid the fees ( Value 1-6 in numerical)

column I to N has the heading Sem 1, Sem 2 and so on till Sem 6
In these columns adjacent to the student name I should get the value from the amount column E
Like when I fill the student E the first time on 1st Jan and mention in sem column as 1 the sem 1 column shows 10 against e
then again when I fill the student E the second time on 3rd Aug and mention in sem column as 2 the sem 2 column shows 15 against e
So on when I fill the student E the next time on 5th sept and mention in sem column as 3 the sem 3 column shows 12 against e

[TABLE="width: 1016"]
<tbody>[TR]
[TD]date[/TD]
[TD]student name[/TD]
[TD]COURSE NAME[/TD]
[TD]sem[/TD]
[TD]amount[/TD]
[TD][/TD]
[TD]MASTER LIST[/TD]
[TD]COURSE NAME[/TD]
[TD]sem 1[/TD]
[TD]sem 2[/TD]
[TD]sem 3[/TD]
[TD]sem 4[/TD]
[TD]sem 5[/TD]
[TD]sem 6[/TD]
[/TR]
[TR]
[TD]01-Jan[/TD]
[TD]a[/TD]
[TD]BA[/TD]
[TD]1[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]a[/TD]
[TD]BA[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01-Jan[/TD]
[TD]b[/TD]
[TD]MA[/TD]
[TD]1[/TD]
[TD]20[/TD]
[TD][/TD]
[TD]b[/TD]
[TD]MA[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01-Jan[/TD]
[TD]c[/TD]
[TD]MA[/TD]
[TD]1[/TD]
[TD]20[/TD]
[TD][/TD]
[TD]c[/TD]
[TD]MA[/TD]
[TD]10[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01-Jan[/TD]
[TD]d[/TD]
[TD]BA[/TD]
[TD]1[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]d[/TD]
[TD]BA[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01-Jan[/TD]
[TD]e[/TD]
[TD]BA[/TD]
[TD]1[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]e[/TD]
[TD]BA[/TD]
[TD]10[/TD]
[TD]15[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jan-18[/TD]
[TD]f[/TD]
[TD]BA[/TD]
[TD]1[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]f[/TD]
[TD]BA[/TD]
[TD]10[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01-Jan[/TD]
[TD]g[/TD]
[TD]BA[/TD]
[TD]1[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]g[/TD]
[TD]BA[/TD]
[TD]10[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01-Jan[/TD]
[TD]h[/TD]
[TD]MA[/TD]
[TD]1[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]h[/TD]
[TD]MA[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]03-Aug[/TD]
[TD]c[/TD]
[TD]MA[/TD]
[TD]2[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]03-Aug[/TD]
[TD]f[/TD]
[TD]BA[/TD]
[TD]2[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]03-Aug[/TD]
[TD]e[/TD]
[TD]BA[/TD]
[TD]2[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]03-Aug[/TD]
[TD]g[/TD]
[TD]BA[/TD]
[TD]2[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]05-Sep[/TD]
[TD]e[/TD]
[TD]BA[/TD]
[TD]3[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]05-Sep[/TD]
[TD]b[/TD]
[TD]MA[/TD]
[TD]2[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]05-Sep[/TD]
[TD]d[/TD]
[TD]BA[/TD]
[TD]2[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[JustynaMK]

Hi apgmin,

Assuming that your table is organised as follows:
- headers in row 1
- "date" to "amount" fields present in columns A-E
- "MASTER LIST" to "sem 6" fields present in column G-N

Then you can try using the following formula in cell I2 (drag it down & across to see the remaining values):
=SUMIFS($E:$E,$B:$B,$G2,$C:$C,$H2,$D:$D,RIGHT(I$1,1))

Please note that the final values are slightly different to what you presented in your post (e.g. results for student "b"), but I will let you revise it.
Let me know if that helps.