Average an Excel range - ignoring blank, text or error cells
Download the case study workbook here: https://spreadsheetvault.com/average-...
0:00 Intro
0:44 1st approach using AVERAGEIFS
1:40 Complete formula of 1st AVERAGEIFS
1:51 2nd approach using AVERAGEIFS
2:42 Complete formula of 2nd AVERAGEIFS
3:00 Summary of 2 AVERAGEIFS
This video will show you one approach to average across blank, text or error cells in a financial model. There is some trade data in the video with the following details, which contain some ad-hoc errors and omissions.
The standard AVERAGE function in Excel will be unable to work with a range, which contains non-numerical cell values such as text, blanks or text.
We need an alternative function and formula, which will return an average value of 37,527, as per the following example.
There are two approaches we will use to solve this, which is a follow-up to an earlier video, "Sum an Excel range - ignoring blank, text or error cells" ( • Sum an Excel range - ignoring blank, text ... )