by Ilker | Jul 13, 2018 | Excel Formulas, 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 Formulas, 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 Formulas, 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 Formulas, 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 Formulas, 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...
by Ilker | Apr 25, 2018 | Excel Formulas, Excel Tips & Tricks
To return an entire column you need 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...
by Ilker | Apr 2, 2018 | Excel Tips & Tricks
A final exam is worth more in terms of graduation score and the term weighed average becomes relevant. In such cases, SUMPRODUCT formula can help calculate the weighed totals of a data set. In our example, test scores of 3 candidates are being compared. Although...
