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" <JMS@discussions.microsoft.com> wrote in message
news:15A369D1-561E-4616-B0EB-0FA36A703566@microsoft.com...
> 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.