J Jacob Skaria Jun 10, 2009 #2 =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
=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 Jun 10, 2009 #3 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
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 Jun 11, 2009 #4 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.
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.
