View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Joe is offline
external usenet poster
 
Posts: 476
Default 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