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?
|