AVERAGE Articles: Excel and Google Sheets

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...

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...

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...

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...

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...

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...

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...

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...

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...

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:...