Total and summarise data
 

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

--
Cheers

Total and summarise data
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dan" wrote in message
...

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

--
Cheers