Excel can be a powerful tool for your business, but it can also be daunting with its many formulas, charts, and formatting. Here we’ll take a look at two simple but very useful Excel formulas, and how to make them work for you. Follow these tips to add up numbers or average them!

Adding Up Numbers

You have multiple columns or rows of numbers. You don’t want to have to add them all up on your calculator, and you don’t want to have to re-add them if the numbers change. The simplest solution? Use AutoSum!

To add up a row or column of numbers, highlight all of the cells you want to add up (either vertically down a column or horizontally in a row). Then click AutoSum on the Ribbon in the Editing group. This will quickly add the sum of your selected cells in a cell below or to the right of your selection.

AutoSum in Excel

If you want to type the SUM formula, click in any empty cell and type =SUM(CELL:CELL). CELL:CELL are the first and last cells in your range. Therefore, a finished formula would look like =SUM(A1:A12). Press Enter on your keyboard and your sum should appear!

Excel Formulas: SUM

Averaging Numbers

The AVERAGE formula works the same as the SUM formula. To use it, select a range of numbers. Then click the down arrow next to AutoSum on the Ribbon. From the drop-down list, select Average.

Average from AutoSum in Excel

If you want to type the AVERAGE formula, it works the same way as the SUM formula as well. In a blank cell, type =AVERAGE(CELL:CELL). Again, CELL:CELL are the first and last cells in the range you want to average. Then hit Enter on your keyboard and your average number will appear.

Excel Formulas: AVERAGE

Now you can use two of the easiest, most common Excel formulas!


Cybersecurity during COVID-19

Feeling the COVID-19 Panic? Don’t Forget Your Cybersecurity

| Leadership, Security | No Comments
Attackers Are Taking Advantage of Unprecedented Changes What we’re witnessing today with the COVID-19 pandemic is unprecedented. Local governments are banning large gatherings. Many businesses and institutions are forced to close or adjust work schedules. Organizations that can are moving their employees to reduced hours or remote work. This means many people are now working from home for the first time and encountering issues with connectivity and access to company networks and data. The social isolation, uncertainty, and distractions cause anxiety and mistakes. On top of all of this, cyber attackers are already trying to take advantage of a world…

An Update from OXEN Technology

| Announcements | No Comments
To all our valued clients Much has changed across the country and across the world in the past few weeks. We want to let you know how OXEN has adapted to the COVID-19 pandemic and what precautions we are taking, while also serving you remotely. Do you need help with remote work? First and foremost, we know many organizations and businesses are taking quick action to set up remote workers and work-from-home policies. Many of your employees are working remotely for the first time and experiencing the technical hurdles that come with that transition. If you are having any problems…
Managed IT Services

3 Signs You Need Managed Services

| Managed Services | No Comments
If you've researched methods of taking care of your IT needs, you've probably come across "managed services" or "managed IT services". What is it—and do you need it? "Managed services" can be generally defined as "outsourcing day-to-day management responsibilities for improving operations and cutting expenses."1 When it comes to technology, managed services is, more specifically, the outsourcing of continual monitoring and day-to-day administrative duties of your IT infrastructure. How do you know if you could benefit from managed services? The best way to determine if you'll cut costs is to know what you are currently paying for your IT's upkeep—and…