by Ilker | Oct 26, 2018 | Excel Formulas
AVERAGIFS function can calculate the average in a range of cells, based on a criteria. In this guide, we’re going to show you how to use the AVERAGIFS function and go through some examples, as well as error handling methods. Supported versions (Windows) Excel 2007 and...
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 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...