Solved

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

Posted on 2016-09-01
7
47 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 32

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 32

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 29

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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 32

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 29

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

778 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