Thread: Using formulas betweek worksheets

How do I calculate between worksheets?
--
stricktd

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

=sheet1!a1+sheet2!a3

--
Don Guillett
SalesAid Software
donaldb@281.com
"stricktd" <stricktd@discussions.microsoft.com> wrote in message
news:5968E7CA-422B-48D5-A96D-F12F28ACB870@microsoft.com...
> How do I calculate between worksheets?
> --
> stricktd

Just reference the other sheet in the formula

=Sheet2!A10*100

--

HTH

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


"stricktd" <stricktd@discussions.microsoft.com> wrote in message
news:5968E7CA-422B-48D5-A96D-F12F28ACB870@microsoft.com...
> How do I calculate between worksheets?
> --
> stricktd

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" <stricktd@discussions.microsoft.com> wrote in message
news:5968E7CA-422B-48D5-A96D-F12F28ACB870@microsoft.com...
> How do I calculate between worksheets?
> --
> stricktd