Average function with Condition

Dear All,

I have a row with numbers like.

1 2 4 0 0 7 8 6 8

Now i want to have average of all the numbers in a row but excluding the cells having 0. When i apply average function i get average as 4 but what i want is Average 5.14 which is excluding the cells having 0s.

PLEASE HELP

Regards
Mohammad

Try this for range A16:I16

Please Login or Register  to view this content.