S
stricktd
How do I calculate between worksheets?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
bpeltzer
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.
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.
D
Don Guillett
=sheet1!a1+sheet2!a3
B
Bob Phillips
Just reference the other sheet in the formula
=Sheet2!A10*100
--
HTH
RP
(remove nothere from the email address if mailing direct)
=Sheet2!A10*100
--
HTH
RP
(remove nothere from the email address if mailing direct)
P
Peo Sjoblom
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)
=SUM(Sheet1:Sheet3!A1:A10)
will sum a1:a10 in Sheet1 to 3
--
Regards,
Peo Sjoblom
(No private emails please)