The AVERAGE function in Google Sheets is useful if you want to get the average value of a data set.
Table of Contents
The AVERAGE
function does this simply by providing the data range that you want to average. This would surely cut off the process of adding and dividing values.
Let’s take an example.
Say we have 50 employees under our Sales team.
We want to check the average salary of the Sales team.
So how do we do that?
Simple. We can use our AVERAGE
function to get the average salary of our Sales team. We just have to select the data range, which is the salary portion.
The function will automatically output to the average salary.
The AVERAGE
function seems easy. Surprisingly, it is helpful in a lot of circumstances. You can use it to average grades, points, records, and a lot more.
Easy, right?
Let’s go straight into real-business examples where we will deal with actual values and textual strings and how we can write our own AVERAGE function in Google Sheets to compute those data.
The Anatomy of the AVERAGE Function.
The way we write the AVERAGE
function is as follows:
=AVERAGE(value1, [value2, …])
Let’s break this down to understand better what each terminology means:
=
the equal sign is how we start off every function in Google SheetsAVERAGE()
this is our function. We need to supply a data set so we can see how the AVERAGE function worksvalue1
is a required data to be averaged[value2, …]
is an optional data value.
⚠️ Now a few notes before writing your own AVERAGE function in Google Sheets.
- The
AVERAGE
function can only take a maximum of 30 arguments. - The texts inside the value arguments are completely ignored.
- If you want a text value to be considered as 0 values, you can simply use
AVERAGEA
.
A Real Example of Using AVERAGE Function
The below example shows how AVERAGE
functions are used in Google Sheets.
The example above shows exactly how the AVERAGE
function works to get the mean salary of Sales Agents, Sales Managers, and All Sales Employees. The formula outputs $453.33, $836.67, and $833.50, respectively. The functions are as follows:
=AVERAGE(D5:D7) =AVERAGE(D2,D9,D11) =AVERAGE(D2:D11)
Here’s what this example does:
- We started off by actively selected cell D13 and we want to use the
AVERAGE
function to get the mean salary of sales agents, sales managers, and all sales employees. The results are shown in cells D13, D14, and D15, respectively. - For the first item, we just selected the salary of sales agents. That would be in cells D5 to D7.
- Next, to get the mean salary of sales managers, we selected cells D2, D9, and D11.
- Lastly, we have selected all the salaries in column D to get the mean salary of all employees.
Easy, right? Have a go at it yourself by making a copy of the spreadsheet using the link I have attached below:
AVERAGE
function in Google Sheets.
How to Use AVERAGE Function in Google Sheets
- Click on any cell to make it active so that we can write our formula. For this guide, I have selected cell D13.
- Now, we start to write our formula by typing an equal sign (=). This is how we start any function in Google Sheets. We will follow it up with our function,
AVERAGE
. Remember always to add this before we select our data set.
- Nice! For the first item, we are to get the average salary of sales agents. Therefore, we need to look out for all ‘sales agents‘ in our database and select their salaries. For this guide, I have chosen cells D5:D7.
- Let’s close our formula with a close parenthesis, “)” and hit on the Enter key.
- Good work! Let’s do the same process for the next items. We need to look out for all ‘sales managers‘. So we need to select the cells D2, D9, and D11. After closing it up and hitting on the ‘Enter key’, you should have an answer of $836.67.
- Lastly, to get the average salary of all sales employees, we will simply select all the salaries in column D. Hit on the ‘Enter’ key, and you’re done!
That’s pretty much it. You can now use the AVERAGE
functions together with the other numerous Google Sheets formulas to create even more powerful formulas that can make your life much easier. 🙂
