Total and summarise data

D

Dan

Hello

I have 51 sheets in the same workbook.
The front sheet is a summary sheet of the 50 behind.
Each sheet has a list of codes with a value next to it, but the same code is
not on the same line in each sheet.
On the summary sheet I would like to add up all the values inline with a
specific code

What is the easiest way of doing this?

Thanks
 
B

Bernard Liengme

Maybe not the best solution but here is one way.
In A1:A20 of Sheet1 to Sheet3 I have letters A, B,....
In B1:B20 on these sheets I have numbers
On Sheet 4 (summary sheet) in A1 I have the code (letter) to lookup (say, X)
In cells A26 of Sheets 1 to Sheet3 I have =SUMIF(A1:A20,Sheet4!A1,B1:B20)
On Sheet4 (summary sheet) in B1 I have =SUM(Sheet1:Sheet3!A26)
best wishes
 
Top