Thread: Refer to Another Spreadsheet in a Formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey Duke Carey is offline
external usenet poster
  
Posts: 1,081
Default Refer to Another Spreadsheet in a Formula
In the cell where you want the result, type;

=sum(

then press Ctrl-F6 to switch to the workbook containing the range to be
summed. Highlight the desired cells, and press Enter

"DOUG" wrote:

How would I tell a formula to go to another spreadsheet and to take the sum
of a specified range?

DOUG
Reply With QuoteReply With Quote