Solved

How can I get autosum to automatically highlight totals as well as numbers?

Posted on 2016-09-01
7
56 Views
Last Modified: 2016-09-02
I'm attaching a file with a total of numbers (F7)  and then another number. When I insert autosum underneath them to add them up, Autosum just picks up F8 instead of autoselecting F7 and F8. How can I get it to do its usual thing of automatically putting its "marching ants" around the F7:F8 range. Thanks
EE-Excel-autosum-question.xlsx
0
Comment
Question by:agwalsh
  • 3
  • 2
  • 2
7 Comments
 
LVL 33

Expert Comment

by:Rob Henson
ID: 41780062
The AutoSum is clever enough to recognise the contents of a cell already being a SUM.

With your sample, use the AutoSum in F9 and accept just the one cell. Then go to F10 and try another AutoSum. This time it recognises the two sums above and suggests adding those.

That is the way AutoSum is supposed to work. Sometimes Excel can be too clever for its own good and doesn't always do what we expect or want.
0
 
LVL 33

Accepted Solution

by:
Rob Henson earned 350 total points
ID: 41780066
If you highlight the cells to be summed first ie F7 and F8 and then click the AutoSum it will do what you are expecting.
0
 
LVL 30

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41780090
Autosum will not include any cell with the SUM formula in the range to be summed up.
Try Rob's suggestion, that would do the trick.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 33

Expert Comment

by:Rob Henson
ID: 41780098
@Neeraj - not strictly true, the AutoSum will choose cells containing SUM if they "appear" to be the only cells valid to SUM; as suggested in my first comment when doing the AutoSum on the next cell again, it SUMs the previous SUMs.
0
 
LVL 30

Assisted Solution

by:Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj) earned 150 total points
ID: 41780113
Yeah that's correct Rob!
I meant that if one cell has a SUM formula in itself and other cells contains only numbers, the autosum will behave incorrectly. i.e. the cells content must be homogeneous.
0
 

Author Comment

by:agwalsh
ID: 41780125
Yeah, I get I can just select the other cell with the summed numbers but I just like the elegance of Excel automatically anticipating what I want (yes, I know this is a 1st World problem LOL). Will check out the highlight thing...
0
 

Author Closing Comment

by:agwalsh
ID: 41781140
Got the answer I wanted - a workaround :-)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question