Blog

BNMC Blog

Bredy Network Management Corporation (BNMC) has been serving the Northeast area since 1988. BNMC works as a strategic business partner to provide organizations with proven design, implementation and support solutions.

Tip of the Week: Calculate a Column’s Sum in Excel

Tip of the Week: Calculate a Column’s Sum in Excel

Excel can be a remarkably powerful tool when it’s leveraged correctly, giving you the power to manage your spreadsheets and data in ways you could only dream of otherwise. Like many other solutions out there, you have numerous shortcuts at your disposal which you can utilize to get more value out of it. Today, we want to share how you can get the sum of the values in a single column.

How Excel Can Sum Up the Values in a Column

Imagine that you keep an inventory of all your desktop monitors in the office, not just the models and who owns them, but also how many of them you have.

Using Excel, you could easily keep track of which models you had in the office, and how many of them.

It’s pretty simple to do this, and most users would solve the dilemma by using the formula =SUM(B1:B10) in Cell B11. However, there is a different and easier way to do this, and it’s outlined below:

  • Select the cell directly below the list you want to total up. In our situation, it would be B11.
  • Hold down the Alt key and press the equals sign (=) key.

  • Hit Enter

You’ll see the sum of the values in the column above your selected cell.

You can see the total here is 43, and all it took was a couple of keystrokes to make it happen!

Make Technology Simple

Your business can benefit a lot from making technology easier to manage and use, and with BNMC on your side, you can do just that. To learn more, call us today at (978) 482-2020.

 

Comments

No comments made yet. Be the first to submit a comment
Guest
Already Registered? Login Here
Guest
Thursday, 21 November 2024

Captcha Image

News & Updates

Woburn, MA – BNMC is honored to announce that we have been named a finalist in the inaugural MSP Titans of the Industry Awards for 2024. This recognition highlights our commitment to excellence, innovation, and leadership within the Managed Serv...

itc

Contact us

Learn more about what BNMC can do for your business.

Copyright BNMC. All Rights Reserved. Privacy Policy