Skip to main content

Excel Tips: Calculation & Formulas > Statistic Functions

Author: Kelly Last Modified: 2020-03-23

AVERAGE Function

Average by date

How to average based on day of week in Excel?

How to average data based on weekday or weekend in Excel?

How to average per day/month/quarter/hour with pivot table in Excel?

How to average timestamps of day in Excel?

How to calculate average age by year/month/date in Excel?

How to calculate average between two dates in Excel?

How to calculate midpoint between two dates in Excel?

How to calculate weekly average in Excel?

How to sum or average values if dates in adjacent cells equal to specified month in Excel?

Average ignoring cells

How to average a range of data ignoring zero in Excel?

How to average cells ignoring error values in Excel?

How to average filtered cells/list in Excel?

How to average for cells with values only (exclude 0 or blank cells) in Excel?

How to average last 5 values of a column as new numbers entering?

How to average non-adjacent/contiguous cells excluding zeroes in Excel?

How to average only positive or negative numbers in Excel?

How to average right result with missing values in Excel?

How to average top or bottom 3 values in Excel?

How to calculate average without max and min values in Excel?

How to drop the lowest grade and get the average or total of values in Excel?

How to quickly average visible/filtered cells only in Excel?

How to sum / average ignore negative values in Excel?

How to sum or average unique values only in Excel?

Average with criteria

How to average cells based on multiple criteria in Excel?

How to average every 5 rows or columns in Excel?

How to average multiple vlookup findings in Excel?

How to average values based on cell color in Excel?

How to average values if another column contains certain text in Excel?

How to calculate average in a column based on criteria in another column in Excel?

How to calculate average numbers greater than 0 in Excel?

Weight average

How to calculate weighted average in an Excel Pivot Table?

How to calculate weighted average in Excel?

How to ignore blanks when calculate the weighted average in Excel?

Others

How to average absolute values in Excel?

How to average range with rounding in Excel?

How to calculate average cells from different sheets in Excel?

How to calculate average of dynamic range in Excel?

How to calculate average rate of change in Excel?

How to calculate average speed from distance and time in Excel?

How to calculate average/compound annual growth rate in Excel?

How to calculate moving/rolling average in Excel?

How to calculate running total /average in Excel?

How to count blank cells as zero when using AVERAGE in Excel?