WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android


How to use average function in excel on mac

July 26, 2022

The average (arithmetic mean) of a set of numbers is determined by Excel's AVERAGE function. The AVERAGE function disregards logical values, blank cells, and text-filled cells.

The Excel Statistical functions section includes the AVERAGE Function[1]. In Excel, it will return the mean value of the supplied set of numbers. In Excel, the function is used to determine the arithmetic mean of a set of inputs. This tutorial will walk you through each step of computing the average in Excel. The function is helpful to a financial analyst in determining the average (mean) of a set of statistics. For instance, we can discover the average revenue for a company over the previous 12 months.

 Average function in excel online, 2016 and 2019

Use SUM and COUNT instead of the AVERAGE function.

The AVERAGE function, for instance, determines the average of the values in cells A1 through A3 in the example below.

1.The same outcome is obtained using the formula below.

2.The average of the values in cells A1 through A3 and the number 8 is determined by the following AVERAGE function.

3.The AVERAGE function disregards text-filled cells, empty cells, and logical values (TRUE or FALSE).

AverageA function in excel

1.The average (arithmetic mean) of a set of numbers is another result of the AVERAGEA function. However, the logical value TRUE evaluates to 1 while the logical values FALSE and cells with text evaluate to 0. Additionally ignoring empty cells is the AVERAGEA function.Look at the AVERAGEA function below as an illustration.

2.You can verify this outcome using the standard AVERAGE function.

Average top 3 in excel

1.To determine the average of the top 3 figures in a data set, use Excel's AVERAGE and LARGE functions.The first step is to determine the average of the values in cells A1 through A6 using the AVERAGE function below.

2.Use the LARGE function, for instance, to determine the third-largest number.

3.The average of the top three numbers is calculated using the formula below.

4.The array constant 20,15,10 is returned by the LARGE function, as explained. The AVERAGE function receives this array constant as an argument, returning a value of 15.

Average If function in excel

1.Use Excel's AVERAGEIF function to determine the average of all cells that satisfy a particular criterion.

Note: This above written article is an attempt to show you how to use average function in excel online, 2016 and 2019, in both windows and mac.You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.                                  

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.