Hi Taha,

Am Wed, 20 Nov 2013 05:00:12 -0800 (PST) schrieb Taha Sk:

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

your Account No in A2:A4
Then in B2 for Item1 and Item2:
=SUM(INDEX(Sheet1!B:C,MATCH(A2,Sheet1!$A$1:$A$4,0) ,))

In B2 for Item2 and Item3:
=SUM(INDEX(Sheet1!C:D,MATCH(A2,Sheet1!$A$1:$A$4,0) ,))


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2