if is error then "No Data", if not then average range
in [Functions]
|
Prev: Calculations in filtered columns
Next: Transfering a changing cell value progressively through a work
From: SK08 on 4 Feb 2010 15:36 I believe the formula should be something like: iferror(average(C1:F1=TRUE,"No Data), average(C1:F1)
From: Teethless mama on 4 Feb 2010 16:21
=IFERROR(AVERAGE(C1:F1),"No Data") "SK08" wrote: > I believe the formula should be something like: > iferror(average(C1:F1=TRUE,"No Data), average(C1:F1) > . > |