formula that accesses data from another sheet

  • Thread starter Thread starter SteveZmyname
  • Start date Start date
S

SteveZmyname

Hello
If I have data in one sheet how can I display the number in a different sheet.
Example, a sheet thats named data to display on another sheet named chart.
a formula like =SUM(L6:O6) would I assume go in the destination sheet.

thanks for any help
Steve
 
Hi,

You would need to include the sheet name in the range reference.

=SUM(Data!L6:O6)

Cheers
Andy
 
Back
Top