Using formulas betweek worksheets
 

How do I calculate between worksheets?
--
stricktd

Using formulas betweek worksheets
 

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

Using formulas betweek worksheets
 

=sheet1!a1+sheet2!a3

--
Don Guillett
SalesAid Software

"stricktd" wrote in message
...
How do I calculate between worksheets?
--
stricktd

Using formulas betweek worksheets
 

Just reference the other sheet in the formula

=Sheet2!A10*100

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stricktd" wrote in message
...
How do I calculate between worksheets?
--
stricktd

Using formulas betweek worksheets
 

What do you mean by that?

=SUM(Sheet1:Sheet3!A1:A10)

will sum a1:a10 in Sheet1 to 3

--
Regards,

Peo Sjoblom

(No private emails please)


"stricktd" wrote in message
...
How do I calculate between worksheets?
--
stricktd