if is error then "No Data", if not then average range

S

SK08

I believe the formula should be something like:
iferror(average(C1:F1=TRUE,"No Data), average(C1:F1)
 
Top