I have several numbers highlighted in Excel. When I look to the lower right
hand section of the Excel Window, I can see the sum of those numbers. If I
right click the sum, I can change to the maximum, the minimum, the average
and so forth. There are times it would be useful to capture the sum and be
able to copy the answer into a cell. I used to know how to do this but can
not remember now for the life of me. It doesn't wrk to ctrl+c and you can't
right click. Can anyone enlighten me? Thanks in advance.

Click the autosum icon (sigma) with your cursor in the cell where you
want this to appear. Alternatively, enter the formula:

=SUM(A1:A10)
or even:
=SUM(A1:A3,B3,C15:C20)

if you have non-contiguous data.

Hope this helps.

Pete

On Jan 24, 12:00*pm, tzap_1998
wrote:
I have several numbers highlighted in Excel. When I look to the lower right
hand section of the Excel Window, I can see the sum of those numbers. If I
right click the sum, I can change to the maximum, the minimum, the average
and so forth. There are times it would be useful to capture the sum and be
able to copy the answer into a cell. I used to know how to do this but can
not remember now for the life of me. It doesn't wrk to ctrl+c and you can't
right click. Can anyone enlighten me? Thanks in advance.