by Ilker | Nov 21, 2019 | Excel Formulas
The AVERAGEA in Excel is a Statistical function that can calculate and return the average (arithmetic mean) of the values of a range of cells. AVERAGEA differs from the AVERAGE function in its ability to include numbers in string format and logical values in the...
by Ilker | May 9, 2019 | Excel Formulas
The MEDIAN Excel function is a Math formula that calculates and returns the median of the selected values. The median in statistics represents the middle value in a dataset. In this guide, we’re going to show you how to use the Excel MEDIAN function and also go over...
by Ilker | Jan 9, 2019 | Excel Formulas
The AVERAGE function can calculate the average (arithmetic mean) of the values in a range of cells. In this guide, we’re going to show you how to use the function and also throw in some tips and error handling methods.Supported versionsAll versionsSyntax...
by Ilker | Dec 21, 2018 | Excel Formulas
AVERAGEIF function takes the average of the values in a range of cells that match a criteria. In this guide, we’re going to show you how to use the AVERAGEIF function and also go over some tips and error handling methods.Supported versionsAll Excel versionsSyntax...
by Ilker | Jul 13, 2018 | Excel Tips & Tricks
Calculating averages by week number is a bit different than doing this by month. Instead of finding start and end dates of date range, we focus on the exact week number using the WEEKNUM function. Syntax =AVERAGEIFS( range of values to calculate average, range of week...
by Ilker | Jun 13, 2018 | Excel Tips & Tricks
The AVERAGEIFS function can calculate the average of values with multiple conditions. However, these conditions are linked with AND operator. But if you want to handle AVERAGE OR combination, AVERAGEIFS function will not work. This article shows how to calculate...
by Ilker | Jun 12, 2018 | Excel Tips & Tricks
This article shows how to calculate average with intersecting tables using AVERAGE function and intersect operator, the space character (” “). Syntax =AVERAGE(first range second range) Steps Type =AVERAGE( function Select or type the first range reference...
by Ilker | Jun 11, 2018 | Excel Tips & Tricks
This article shows you how to calculate monthly averages from a data table containing dates and values using AVERAGEIFS and EOMONTH functions. If you only want to calculate the number of days in a month, please refer to the article: How to find number of days in month...
by Ilker | Apr 25, 2018 | Excel Tips & Tricks
To return an entire row you need to use array returning functions like INDEX or OFFSET. Both of these functions can return arrays, as well as single values, which can be used in other functions like SUM, AVERAGE or even another INDEX or OFFSET. How to return an entire...