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?