Thread: AutoSum
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.newusers
MartinW[_2_] MartinW[_2_] is offline
external usenet poster
 
Posts: 168
Default AutoSum

Hi CC,

Maybe this is what you are trying to do.

With your data in place in A1:A10 as per your example,

Highlight from A1:A15
Then click the AutoSum button.

HTH
Martin



"CC" wrote in message
...
Okay - this is what I'm doing that is not working....
In cell A1 I have 2 in the cell.
A2 = 2
A3 = 2
A4 - I autoSumed and total is 6. Then in A7 = 2,
A8 = 2
A9 = 2
A10 = AutoSummed and total is 6. Now I want to add A4 and A10. I'm
holding
down the control key and clicking on A4 and then A10, then clicking on a
clear cell where I want the sum, say A15. Then I'm clicking AutoSum and
it's
coming up with 6 instead of 12. What am I doing wrong please?
--
CC


"Gord Dibben" wrote:

See other replies for summing selected cells by autosum in a cell.

If you just want to see the sum without using a formula, CTRL + click on
the
cells then right-click on Status Bar and "SUM"


Gord

On Mon, 27 Oct 2008 13:27:03 -0700, CC
wrote:

Well, I just realized what I was asking didn't really make sense. In
other
words, I probably would never want to do that. Can you tell me how to
select
and add two different totals together? I'm able to select them by using
the
control key, but I can't figure out how to add them together without
having
to build a formula. Thank you so much.