Mark

I assume you mean the SUM down on the Status Bar.

AFAIK there is no way to copy this number.

Workaround........select the cells then hit the AutoSum button on your
Standard Toolbar.

Copy and Paste SpecialValues to the other workbook or sheet.


Gord Dibben Excel MVP

On Wed, 9 Feb 2005 07:59:06 -0800, "MarkT"
wrote:

In excel, when you hi-light a column of numbers, the program automatically
sums the hi-lighted numbers. My question is this, is there a way to copy
this auto sum total to another speadsheet that I have open?

Thanks for your help!