Hello,
I am using this formula: =IF(ISERROR(AVERAGE(AK8:AK14)),"",AVERAGE(AK8:AK14))
I need it to ignore any 0 values in the average.
Hello,
I am using this formula: =IF(ISERROR(AVERAGE(AK8:AK14)),"",AVERAGE(AK8:AK14))
I need it to ignore any 0 values in the average.
Try
=IF(ISERROR(AVERAGEIF(AK8:AK14,"<>0")),"",AVERAGEIF(AK8:AK14,"<>0"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks