if the values are in cells A1 on sheet 2 & 3 try =Sheet2!A1+Sheet3!A1 in the
cell where you want the result. Easy way is to put = in the formula bar and
click on the sheet tabs and cells you want, clicking on the tick in the
formula bar to confirm the formula
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Scott" wrote:

I would like to know how to add individual cells on multiple worksheets in a
workbook. I have a column of numbers that adds the total value into a cell.
Now I want to add that cell along with the same information from other sheets
onto a main sheet. I'm not sure if SUM function is right? Any help would be
appreciated. Thanks, Scott