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!


Ransomware - Cybersecurity Banner

Ransomware Lessons for City Governments

| Security | No Comments
U.S. towns and cities are being hit hard by ransomware and cyberattacks A city government's network is a prime target for hackers. Many small towns and cities don't have the tools, personnel, or budget to fight back. And when an attack is successful, who is to blame? Cities like Lake City, Florida have been in the news recently for falling victim to devastating ransomware attacks and the consequences afterwards. Lake City, Florida's computer network was devastated within hours. Their security and backup defenses were no match for expert hackers and sophisticated spear phishing campaigns. Their budget never extended to cover…

Create Rules to Automatically Sort Incoming Mail in Outlook

| Tech Tip | No Comments
When you receive a lot of email, your inbox becomes cluttered and difficult to navigate. Thankfully, you can use create Rules in Outlook to sort your incoming email. Here are the steps to set up a rule in Outlook that will automatically put incoming mail from a particular sender into a specific folder: Select an email in your Inbox from the sender you’d like to create a new folder for. Go to Rules > Create Rule on the toolbar. Check the “From…” box at the top of the Create Rule window. Check “Move the item to folder:” at the bottom…
Happy Halloween from OXEN Technology

Happy Halloween from OXEN

| Holiday | No Comments
We hope you have a safe and fun Halloween, from the team at OXEN