Hi All,

I am trying to sum the values in B, C, D based on the value in column A
------------------------
Available Data
------------------------
Account no. Item1 Item2 Item3
1022 3 1
1023 2 2
1024 2 1

------------------------
What I need.
------------------------
In another sheet I have two table where I want to sum the value from specific column when I fill up the "Account no." column.

For E.g.
In Table 1 Sum the corresponding value from Item1 and Item3 Based on Value in Column "Account No.".

Account No. Sum of Items
1022 3
1023 4
1024 2

Similarly,
In Table 2 Sum the corresponding value from Item2 and Item3 Based on Value in Column "Account No.".

Account No. Sum of Items
1022 1
1023 2
1024 1

On a side note I tried a lot of googling could not find a similar solution. Below is current method which I feel is not very efficient and I believe you guys might have a better solution.

Current Method
Table1
Vlookup(item1) + Vlookup(Item3)

Any help on this is appreciated.

Regards
Taha