Your formula works fine for me, and you adjusted it appropriately.

CHeck to see that the values are actually entered as values, not Text.

In article ,
Naomi wrote:

I adjusted the formula..and for reference there is 11 columns to average
therefore the formula i used was

=IF(COUNTIF(C11:M11,"0")<11,"",AVERAGE(LARGE(C11: M11,{1,2,3,4,5,6,7,8,9,10}))
)

The formula generated by the cell that i placed the formula in is blank no
zero or error message!.

Any ideas??