In you 13 th sheet at c2 cell paste the below formulae

I considered the that there are 400 rows in each sheet.



=VLOOKUP(A2,Sheet1!$A$2:$B$400,2,FALSE)+VLOOKUP(A2 ,Sheet2!$A$2:$B$400,2,FALSE)+VLOOKUP(A2,Sheet3!$A$ 2:$B$400,2,FALSE)+VLOOKUP(A2,Sheet4!$A$2:$B$400,2, FALSE)+VLOOKUP(A2,Sheet5!$A$2:$B$400,2,FALSE)+VLOO KUP(A2,Sheet6!$A$2:$B$400,2,FALSE)+VLOOKUP(A2,Shee t7!$A$2:$B$400,2,FALSE)+VLOOKUP(A2,Sheet8!$A$2:$B$ 400,2,FALSE)+VLOOKUP(A2,Sheet9!$A$2:$B$400,2,FALSE )+VLOOKUP(A2,Sheet10!$A$2:$B$400,2,FALSE)+VLOOKUP( A2,Sheet11!$A$2:$B$400,2,FALSE)+VLOOKUP(A2,Sheet12 !$A$2:$B$400,2,FALSE)


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=318889