S SK08 Feb 4, 2010 #1 I believe the formula should be something like: iferror(average(C1:F1=TRUE,"No Data), average(C1:F1)