Hi,

The formula in question is =IF(ISERR(AVERAGE(IF(C3:C14>0,C3:C14))),0,AVERAGE(IF(C3:C14>0,C3:C14))).

The formula agrement box shows the correct answer for the column which in this case is 3.9 but the cell displays 0.0!!

Can anyone help?

Thanks