You precede the range with the sheet name and !, like so

=SUM(Sheet1!A1:A10)

or in single quotes if the shete name has spaces

=SUM('Some Sheet'!A1:A10)

--
__________________________________
HTH

Bob

"DOUG" wrote in message
...
How would I tell a formula to go to another spreadsheet and to take the
sum
of a specified range?

DOUG