Sure Alex.
I used the Sumif formula, which gives out the sum if a particular condition is met. I used this formula to check all the sheets and then just did a sum of it. If you look at the formula the formula is
=SUM(SUMIF(chai!$A$12:$A$40,$A2,chai!$B$12:$B$40),SUMIF(james!$A$12:$A$40,A2,james!$B$12:$B$40),SUMIF(el!$A$12:$A$40,A2,el!$B$12:$B$40),SUMIF(liu!$A$12:$A$40,A2,liu!$B$12:$B$40),SUMIF(wang!$A$12:$A$40,A2,wang!$B$12:$B$40))
Please let me know if you need any further clarifications. also you can use Evaluate Formula to check the formula.
Cheers-
Inayat
Bookmarks