formula that accesses data from another sheet

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
 
A

Andy Pope

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

Creating a Chart on form from selected data in query. 0
Displaying Data Forms in Excel 2016 for Mac 0
VBA Coding Help for Beginner 0
One extra x axis item that wont go away - can anyone help? 3
Many sheets, one DB? 1
Drop down list control value in vba 2
Using IF statement with sheets 0
Publisher is filling blank lines with data 2

Top