excel

J

Jacob Skaria

=A1
Reference the same sheet

=Sheet1!A1
reference the same cell in a different sheet

=[book1]Sheet1!A1
reference a cell in a unsaved workbook

=[book1.xls]Sheet1!A1
reference a cell in a saved workbook
 
P

Pete_UK

You'll need to give a bit more detail to explain what data you have
and what you are trying to do with it.

Pete
 
J

JLatham

Or even a "3-dimensional" total of values in several contiguous sheets in a
single workbook:
=SUM(Sheet1:Sheet3!B6:B8)
or
=SUM(Sheet1:Sheet3!B9)

But like Pete_UK said - more specific information would help bring in a more
specific response.
 

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 --> Word 4
Update several ppt documents from a single excel file 0
Add results from fields in a form 1
Help creating a search form in Access XP 0
Cell data entering slow! 0
Embed the same Excel multiple times 0
Linking data in MS Word into Excel 5
Is there a function to count how many times a cells value is used? 0

Top