Hi
I need to do sum operation based on following conditions:
1.Each name in table 2 should be compared with names in table 1, if it is compatible or equal then moves to the second conditions.
2. check the names of subjects in table 2 with names of shubjects in table 1. If it is equal then I need to sum all values under each subject in front of each name.

Please see the attached file , I need to get results as in table 2
Thanks

​HiI need to do sum operation based on following conditions:1.Each name in table 2 should be compared with names in table 1, if it is compatible or equal then moves to the second conditions.2. check the names of subjects in table 2 with names of shubjects in table 1. If it is equal then I need to sum all values under each subject in front of each name.Please see the attached file , I need to get results as in table 2Thanks  Read More

​