Average 0 Problem Help

[stephen.smith]

Hi guys i am performing an average formula which ignores 0 values however if there are no figures in the cells to be average i want the result cell to display nothing rather than 0. How can i do this, here is the formula I am using =SUMIF(VZ56:ZX56,">0")/MAX(1,COUNTIF(VZ56:ZX56,">0"))
Thanks
Stephen

 

[anandvarma]

try this

=AVERAGEIF(A2:A7,">0")

 

[stephen.smith]

This gives me an #NA answer.

 

[barry houdini]

Try

=IFERROR(AVERAGEIF(VZ56:ZX56,">0"),"")

 

[anandvarma]

try this

=SUMPRODUCT(--(VZ56:ZX56>0)*(VZ56:ZX56))/SUMPRODUCT(--(VZ56:ZX56>0))

 

[stephen.smith]

Worked a treat, Thanks Barry