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?