I'm facing a problem about average formula that I can not solve at the moment but I know it's quite simple for you.
My excel table is as follow:
a1 b1 c1 d1 e1 f1
0 3 2 0 5 =average(a1:e1)

the problem is I want to average only cells that is greater than 0 (the result must be 3.33, not 2)

Could anyone help me to solve above problem
thanks in advanced.

If only positive numbers and zero will be entered, then use this:

=SUM(A1:E1)/COUNTIF(A1:E1,">0")

If negative numbers can also be used, then use this:

=SUM(A1:E1)/COUNTIF(A1:E1,"<>0")

it works for me. thank you very much