fbpx

Your IT Support Experts

We partner with many types of businesses, and strive to eliminate IT issues before they cause expensive downtime.

Home

Partners

IT Services

Understanding IT

Blog

News

About Us

Contact Us

Support

Free Consultation

Interested in seeing what we can do for your business? Contact us to see how we can help you! Sign Up Today

JensenIT Blog

JensenIT has been serving the Illinois area since 1991, providing IT Support such as technical helpdesk support, computer support and consulting to small and medium-sized businesses.

Tip of the Week: The Easiest Way to Add Up a Column in Excel

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 (847) 803-0044 to find out more about our services.

Securing Your Wireless Network
Understanding the Five Levels of Delegation
 

Comments

No comments made yet. Be the first to submit a comment
Guest
Already Registered? Login Here
Guest
Friday, February 23, 2024

Captcha Image

Customer Login


Latest Blog

From smartphones to laptops and everything in between, our devices are constantly exposed to dirt, dust, and germs. Keeping your technology clean ensures a longer lifespan for your devices and promotes a user’s health. Today, we'll explore four practical tips to help you keep your technology clean and functioning at its best.

Contact Us

Learn more about what JensenIT can do for your business.

JensenIT
1689 Elk Blvd
Des Plaines, Illinois 60016

Sign up for our Newsletter!

Hey! Before you go, subscribe to our newsletter for IT tech tips and advice!