[Beautiful]

how can a formula reference data containd in several sheets or books?

[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

--
If this post helps click Yes
---------------
Jacob Skaria


"Beautiful" wrote:

how can a formula reference data containd in several sheets or books?

[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

On Jun 10, 5:46*pm, Beautiful
wrote:
how can a formula reference data containd in several sheets or books?

[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.

"Beautiful" wrote:

how can a formula reference data containd in several sheets or books?