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

  • Thread starter Thread starter SK08
  • Start date Start date
S

SK08

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