accessing data from another document or tab

A

anjem

Is there any way to run functions with a range from a seperate page o
tab in the same document
 
F

Frank Kabel

Hi
sure. e.g.
=SUM('othersheetname'!A1:A100)
Just enter the foormula name and select the range with your mouse (also
on a different worksheet)
 
Top