How to average with errors in excel

Using the normal average formula in excel when averaging cells that include one or more errors doesn’t work. In this video I show three different ways of averaging values in excel using a formula to ignore all the error values.
=AVERAGE(IF(ISNUMBER(C5:G5),C5:G5," "))
=AVERAGE(IF(ISERROR(C5:G5)," ",C5:G5))
Need to use Ctrl + Shift + Enter to get these two array formulas to work.
=AGGREGATE(1,6,C5:G5)
---------------------------------------------------------------------------------
#exceltutorials #excelformulas #exceltipsandtricks

SUBSCRIBE: goo.gl/c46YPs

VIDEO INFO: These data are related to my PhD research.
---------------------------------------------------------------------------------
IF YOU LIKE THIS VIDEO YOU MAY ALSO LIKE:
- Compare lists to find missing values in excel youtu.be/pW6ZWH7YwZQ
- How to compare two tables in excel using VLOOKUP youtu.be/Ecpt5mDdFxU
- How to separate text in excel youtu.be/r676omY_2V4