Worksheet - Functions from sheet to sheet
 

can a function be placed in worksheet 2 that adds up numbers/data from
worksheet 1?

Yes, for instance

=SUM(Sheet1!A1:A18)

will sum A1:A18 in Sheet1, the easiest way is to type =SUM(
then just use the mouse to select the other sheet tab, then select the range
also with the mouse and finish by pressing enter, then Excel will enclose the
formula with a right parenthesis


Regards,

Peo Sjoblom

"brietve" wrote:

can a function be placed in worksheet 2 that adds up numbers/data from
worksheet 1?

Sure

Simply co to your sheet enter = and then enter the function (I've used SUM)
and click on the other sheet and highlight the cells you want to sum.

=SUM(Sheet1!B7:F7)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"brietve" wrote in message
...
can a function be placed in worksheet 2 that adds up numbers/data from
worksheet 1?