=sum(sheet2!b52+sheet3!b52) etc.

Note the exclamation point between the sheet name and the cell reference.
--
Brevity is the soul of wit.


"desperate measures" wrote:

I've searched the Excel help topics up and down but can't find a concise
answer to the following...
While working in the same workbook, what is the formula that i need to enter
in a particular cell in one worksheet that will give me the sum of other
cells in different worksheets?
For example, in Sheet 1, i want cell A1 to add up cell B52 from Sheet 2,
cell B52 from Sheet 3, etc...
anyone?