Sum the entries in a column by avoiding duplicates in multiple columns

S.No. ID SEM TCP
1 R111010 E1S1 158
2 R111010 E1S1 158
3 R111010 E1S1 158
4 R111010 E1S2 175
5 R111010 E1S2 175
6 R111010 E1S2 175
7 R111010 E2S1 182
1 R111010 E2S1 182
2 R111010 E2S1 182
3 R111010 E2S2 136
4 R111010 E2S2 136
5 R111010 E2S2 136

I need to sum the TCP column by avoiding duplicate entries in ID and SEM. For a single ID, different TCP are there in different SEM. I need to sum the TCP of that student in each SEM by avoiding /neglecting duplicates. Please help me with excel 2010/2007 formula.

Maybe if you attach a sample with the expected outcomes next to the table.

thank you sir for your response. please see the attachment with output should be and discription

nflsales,
thank you for your reply. But output should be column should not be considered as reference. I keep that column to tell how the output should be. that column will not be in my database. One more thing, the same should be applicable to more than one student. please see the attachment.

OR,

Try the following in E2:

Please Login or Register  to view this content.

drag it down the cells (See the attached file).

leelnich,

please see the attachment now. it is final copy modified. In that output should be and description columns are kept to explain in detailed. these two columns will not be in my database. I need to sum each student's TCP cumulatively till the end by avoiding duplicate entries/repeated rows.

nflsales,

the Column E (output should be) should not be used as data. For viewers convenience I manually typed the result. I need the output like that with formula.

nfsales,
Thank you so much for your reply. And the formula mentioned in column #H in the attachment is working as i need. Its a great help to me. thank you once again.