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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Count the columns from one sheet and paste it in another sheet 0
Excel Excel Vlookup formula based on cell data 7
One Chart, Same Data ranges, different source sheets 4
How to display the Chart Name as a Chart Title? 1
Excel Formula - Count Dates from another Sheet 8
One extra x axis item that wont go away - can anyone help? 3
copy chart between multiple sheets in workbook 4

Back
Top