a problem of average formula

[cuongvt]

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.

[mangesh_yadav]

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

- Mangesh

[Domenic]

Also...

=AVERAGE(IF(A1:E1>0,A1:E1))

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

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.