## Apex Technology Blog
Apex Technology has been serving the Carolinas since 1998, providing IT Support such as technical helpdesk support, computer support and consulting to small and medium-sized businesses.
[ Categories ](https://trustapex.directivesites.com/blog/categories "Categories")
[ Tags ](https://trustapex.directivesites.com/blog/tags "Tags")
[ Categories: All Categories ](https://trustapex.directivesites.com/javascript:void(0); "Categories")
Search...Suggested keywords
[ x ](https://trustapex.directivesites.com/javascript:void(0);)
# Tip of the Week: The Easiest Way to Add Up a Column in Excel
[Apex Technology Blog ](https://trustapex.directivesites.com/blog/categories/blog) [Tip of the Week](https://trustapex.directivesites.com/blog/categories/tip-of-the-week)
[Tim Campbell](https://trustapex.directivesites.com/blog/blogger/tim-campbell)
Wednesday, 12 July 2023
[ 0 Comments ](https://trustapex.directivesites.com/blog/tip-of-the-week-the-easiest-way-to-add-up-a-column-in-excel#comments)
[  ](//trustapex.directivesites.com/images/easyblog_shared/July_2023/07-12-23/excelColumns_457661502_400.jpg "Tip of the Week: The Easiest Way to Add Up a Column in Excel")
Microsoft Excel is an extremely capable spreadsheet creation and management tool, made all the more powerful through the inclusion of many handy shortcuts and features. We wanted to share one for a common enough function that you are effectively sure to find a use for it: quickly adding up the values in a single column.
And just know, when we say quickly, we *mean* it.
## How to Have Excel Immediately Sum Up the Values in a Column
Let’s say that you were trying to keep an inventory of all the desktop monitors you had in the office, not just keeping a total for each make and model of monitor, but how many you had cumulatively assembled.
**Using Excel, you could easily keep track of which models you had in the office, and how many of them.**
Simple, right?
Of course, to add them all up, many people might suggest that you would insert the formula **=SUM(B1:B10)** in Cell B11, but there’s an even simpler and faster way to accomplish the exact same thing.
- First, select the cell directly below the list you want totalled up. In our case, that would still be Cell B11.
- Next, while holding down the **Alt key**, press the **equals sign (=)** key.
- Hit **Enter**.
This will immediately give you the sum of the values in the column above your selected cell.
In this case, you can easily see you are in possession of 43 assorted monitors.
## It’s as Simple as That!
We hope this tip helps make your life in the office that much easier. Be sure to check back to see what other tidbits of tech advice and information we have to share, or give us a call at (704) 895-0010 to find out more about our services.
[ ](https://trustapex.directivesites.com/javascript:void(0);) [ ](https://trustapex.directivesites.com/javascript:void(0);) [ ](https://trustapex.directivesites.com/javascript:void(0);)
Tags:
[Quick Tips](https://trustapex.directivesites.com/blog/tags/quick-tips) [Software](https://trustapex.directivesites.com/blog/tags/software) [Microsoft Office](https://trustapex.directivesites.com/blog/tags/microsoft-office) [Tip of the Week](https://trustapex.directivesites.com/blog/tags/tip-of-the-week)
[ Implementing Bring Your Own Device, Without Bringi... ](https://trustapex.directivesites.com/blog/implementing-bring-your-own-device-without-bringing-your-own-risks)
[ Understanding the Five Levels of Delegation ](https://trustapex.directivesites.com/blog/understanding-the-five-levels-of-delegation)
About the author
[  ](https://trustapex.directivesites.com/blog/blogger/tim-campbell)
[Tim Campbell](https://trustapex.directivesites.com/blog/blogger/tim-campbell)
[ ](https://trustapex.directivesites.com/blog/blogger/tim-campbell)
Tim Campbell is the President of Apex Technology which he founded in 1998. In 2009, Apex launched its Managed IT Services division. Since its inception, Apex has become the premier Managed IT Services Companies in the Charlotte metro area specializing in Managed IT, Security, Data Backup & Cloud Computing Solutions.
Author's recent posts
[More posts from author](https://trustapex.directivesites.com/blog/blogger/tim-campbell)
[ Wednesday, 05 August 2026 5 Essential Steps to a More Secure Wireless Network ](https://trustapex.directivesites.com/blog/5-essential-steps-to-a-more-secure-wireless-network)
[ Monday, 03 August 2026 Building a Business Workspace That Fits In Your Backpack ](https://trustapex.directivesites.com/blog/building-a-business-workspace-that-fits-in-your-backpack)
[ Friday, 31 July 2026 The Power of Modern VoIP ](https://trustapex.directivesites.com/blog/the-power-of-modern-voip)
Comments
No comments made yet. Be the first to submit a comment
**** Already Registered? [Login Here](https://trustapex.directivesites.com/component/users/login?return=aHR0cHM6Ly90cnVzdGFwZXguZGlyZWN0aXZlc2l0ZXMuY29tL2Jsb2cvdGlwLW9mLXRoZS13ZWVrLXRoZS1lYXNpZXN0LXdheS10by1hZGQtdXAtYS1jb2x1bW4taW4tZXhjZWw=&Itemid=101)
Thursday, 06 August 2026
Subscribe to the blog (Please fill in your email address to subscribe to updates from this post.)
**Captcha Image**