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, ... )
Смотрите видео Average an Excel range - ignoring blank, text or error cells онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Strategize Financial Modelling 05 Февраль 2019, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 16,236 раз и оно понравилось 52 людям.