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!


Basic math in Excel: Addition, subtraction, multiplication, and division

Basic math in Excel: Addition, subtraction, multiplication, and division

| Tech Tip | No Comments
Are you new to Excel, and not sure where to start with formulas and operations? Many spreadsheets use basic math: adding and subtracting numbers or multiplying and dividing. Understanding these math formulas will help you graduate to more complex equations to manipulate your Excel data. How does basic math work in Excel? Excel uses formulas or functions to manipulate data. A function takes an input, which is the content of cells plus some operating symbols that say what to do with the data. You can input a single cell into a function or a range of multiple cells. For addition,…
Countdown to end of support for Microsoft products in 2020

Keep Your Tech Relevant: Are You Prepared for Microsoft End of Support Deadlines?

| Announcements, Office 365, Security | No Comments
There are multiple Microsoft products reaching end of support in 2020. These versions are being retired and will no longer have technical support. We’ve previously talked about the end of support for the Windows 7 operating system and Windows Server 2008 on January 14, 2020. However, other products are also reaching end of support in 2020. On January 31, 2020, Internet Explorer 10 will be retired. If you're already upgrading to Windows 10 or using Microsoft Edge as your web browser, then you've taken the next step to upgrade from IE 10. Later, in October 2020, Microsoft Office 2010 is…
Merry Christmas from OXEN

Merry Christmas from the OXEN Team!

| Holiday | No Comments
Merry Christmas and Happy New Year from the Team at OXEN Technology!   OXEN Technology is closed December 24th and December 25th for Christmas and January 1st for New Year's Day.