AutoSum will display the sum of all selected cells, regardless of
whether they are all in a contiguous block. Suppose you want to select
and see the total of A1:B10 and F11:G20. Hold down the SHIFT key and
select A1:B10. Release the SHIFT key and hold down the CTRL key. Now
select F11:G20. To select more Areas, keep the CTRL key down and
select the Areas. Note that if you select unwanted cells, you can't
"unselect" them without losing the full selection. If you are
interested, I have code at http://www.cpearson.com/excel/unselect.htm
that allows you to unselect a Cell or Area while keeping the rest of
the selection intact.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

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.