All resources related to AVERAGE for Excel and Google Sheets.

All articles
AVERAGE

Excel AVERAGE Function Examples – AVERAGEIF Excel, Calculate Average Excel

Excel offers several options to find the average of a range of numbers. You could use a formula to do this, but you can also use the AVERAGE function. This is a list of the various tutorials related to using the AVERAGE function. You can use these to learn the...

How to Calculate the Average Growth Rate in Excel

When you are analyzing data or making plans for the future, it helps to know several formulas in Excel that will calculate rates of growth. While some are built into the program, you will need the right formulas to get your desired average growth rate. How to calculate the Compound...

Here is How to Find the Average of Data in Excel Ignoring Zeros

We can use the AVERAGEIF function to calculate the average value for a set of values in excel if not 0. Logical operators like >, <, <>, = and wildcards (*,?) for partial matching are supported by the criteria of AVERAGEIF. The steps below will walk through the process. Figure...

How to Calculate the Geometric Mean in Excel

We can use the GEOMEAN function to calculate the average rate per period for a set of values that is compounded over multiple periods. The geometric mean is the average rate of return of a set of values calculated with the products of the terms. The steps below will walk...

Here’s a Guide on Finding the Median in a Pivot Table

We can use a formula that combines the MEDIAN and IF functions to find the median of a set of data if the values meet a criteria in a Pivot Table. The steps below will walk through the process. Figure 1- How to Find the Median in a Pivot Table...

Here is How You Can Find a Running Average in Excel

We can use a formula that is based on the SUM function to calculate the RUNNING average for a set of values. The running average finds the average continuously from previous data points. The steps below will walk through the process. Figure 1- How to Find a Running Average in...

Learn How to Use the AVERAGEIF Function in Google Sheets

We can use the AVERAGEIF function to calculate the average of numbers in a range that meet the specified criteria in a Google Sheet. Logical operators like >, <, <>, = and wildcards (*,?) for partial matching are supported by the criteria of AVERAGEIF. The steps below will walk through...

How to Calculate a Weighted Average in an Excel Pivot Table

To calculate the weighted average of a data with a Pivot Table, we can add a column to our source data as an intermediate calculation. This is because Excel doesn’t provide a function in the Pivot Table that automatically calculates the weighted average. The steps below will walk through the...

Discover How to Calcuate an Exponential Moving Average in Excel

We can use the Data analysis option in excel to calculate an exponential moving average. An exponential moving average (EMA) places more emphasis on recent data points than a simple moving average which considers all observations within a period. The steps below will walk through the process. Figure 1- How...

Learn How to Find a Median if Your Data Meets Certain Criteria

We can use a formula that combines the MEDIAN and IF functions to find the median of a set of data if the values meet a criteria. The steps below will walk through the process. Figure 1- How to Find the Median if Data Meets Certain Criteria Syntax =MEDIAN(IF(logical_test,value_if_true,value_if_false)) logical_test:...