Blank out zeros but to include Average formula also???

Hi,

Sorry if this is a dumb question.

I want to be able to combine the normal =AVERAGE(IF(A14:C14="","",A14:C14)) but it returns '#value'.

I'm looking to average figures in certain rows but not return this error when I pull the handle down re blank rows etc.

Thanks.

Regards.

Do you just want to exclude 0's from the average ?
FYI, blanks are already excluded by default from an average...

Try
=AVERAGEIF(A14:C14,"<>0")