Formula counting average, eliminating the 0's

[alainess]

I haven't used this formula in a while and forgot how to. Can you please remind on how to include the formula to count the average, however elimninate the cells that are at 0? Was it something like this:
=average(if>0, M6:P6) ?

Please let me know. Thanks.

 

[alainess]

I am on Excel 2007, therefore I will try the newer version formula you provided and if it doesn't work I'll try the other one's.

 

[alainess]

I am on Excel 2007, therefore I will try the newer version formula you provided and if it does not work I'll try the other one's.

 

[alainess]

Yes! this French one worked: =MOYENNE.SI(M6:P6;">0";M6:P6)
I guess the format is a little different in French with the commas and parentheses. They should make the format exactly the same in every language and just have the wording different.

Thank you everyone for your help.

Alain

 

[Aladin Akyurek]

Yes! this French one worked: =MOYENNE.SI(M6:P6;">0";M6:P6)
I guess the format is a little different in French with the commas and parentheses. They should make the format exactly the same in every language and just have the wording different.

Thank you everyone for your help.

Alain

Great. Thanks for providing feedback.