Selecting and viewing sum in status bar across worksheets

[Guest]

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.

 

[Guest]

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

Regards |:>)

 

[Dave Peterson]

I don't think you can.

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.