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

Posted on 2016-09-01
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
Question by:agwalsh
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
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.
LVL 33

Accepted Solution

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.
LVL 31

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.
Independent Software Vendors: 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.
LVL 31

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.

Author Comment

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...

Author Closing Comment

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

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

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…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
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.

759 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