Selecting across worksheets

How do I select across worksheets within a file?

I want to select across worksheets and view the accumulating total at the
bottom of the worksheet.

=SUM(Sheet1!:Sheet3!A3)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JMS" <[email protected]> wrote in message
news:[email protected]...
> How do I select across worksheets within a file?
>
> I want to select across worksheets and view the accumulating total at the
> bottom of the worksheet.