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.
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.
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.