Selecting and viewing sum in status bar across worksheets
 

I know how to CTRL-select non-contiguous cells within a worksheet to view a
sum in the status bar.

But how do I do this across multiple worksheets?

The cells across the worksheets will have different addresses.
I don't want to enter a formula ... I just want to select cells across
multiple worksheets and view a quick summary in status bar.

You have 2 responses to your post of 2 hrs. earlier. Please don't post the
same question multiple times.

Regards |:)

"JMS" wrote:

I know how to CTRL-select non-contiguous cells within a worksheet to view a
sum in the status bar.

But how do I do this across multiple worksheets?

The cells across the worksheets will have different addresses.
I don't want to enter a formula ... I just want to select cells across
multiple worksheets and view a quick summary in status bar.

I don't think you can.

JMS wrote:

I know how to CTRL-select non-contiguous cells within a worksheet to view a
sum in the status bar.

But how do I do this across multiple worksheets?

The cells across the worksheets will have different addresses.
I don't want to enter a formula ... I just want to select cells across
multiple worksheets and view a quick summary in status bar.

--

Dave Peterson