Generally, it's just like calculating within a worksheet, except that you
need to qualify your cell references with the worksheet name. That is,
instead of =A1+B1, you might enter =A1+Sheet1!B1 (add the contents from A1 of
the current sheet to B1 from Sheet1). If your worksheet names have spaces,
you'll need something like =A1+'Sheet Name'!B1.
The same idea can be extended to calculating between workbooks:
=A1+Sheet1!B1+[different_file.xls]Sheet2!C1.
You'll usually create these cell references not by typing but rather by
clicking in the cell you want to refer to.

"stricktd" wrote:

How do I calculate between worksheets?
--
stricktd