AverageIf

Hi, guys.

I am trying to find a formula combining IF and AVERAGE. My point is this:
I have 3 different cells with numbers and want to display the average result in the 4th cell. It works fine only with the AVERAGE function while these numbers are >0. However sometimes I have number 0 in the field. So now, the Average number is not divided by 3, but by the number of cells containing numbers >0. For instance if I have 3, 6, 7 - the average is their sum 3+6+6 / 3 = 5. But if I have 3+6+0, I want the sum to be divided by 2, not by 3.
Any suggestions ?

Awesome! It works! Thanks a lot.

Originally Posted by LaserDance

Awesome! It works! Thanks a lot.

The day you find that one of DO's solution doesn't work, let us know , it will be a première !