COUNTIF then Divide

[rcm1946]

I would appreciate help with the following;

I currently have the following =COUNTIF(B30:M30;">0")
What I want to do is use the result for the above to divide the total in N30. I can do this as two separate functions but wanted to put both in the same function.

Thanks for the help!
Richard

 

[Yahya]

Do you mean this
=N30/COUNTIF(B30:M30;">0")

 

[rcm1946]

Perfect worked fine.

Many thanks for your help.

R