Formula needed please

[xxsalahxx]

I have 50 rows of data entered into a spreadsheet the spreadsheet has 19 questions and I wish to sum only certain ones which i have done so by using analysis
=D2+E2+K2+L2+M2+N2+W2, (that was the easy part).

In my next column i want to divide the total number from the questions answered above, However, if any of the questions were answered using a zero or left blank i want to omit them.
*Example maybe only 5 questions were answered.

Thank you in advance for any help I can receive with this.

 

[xxsalahxx]

I think you have it Glen, thank you so much

 

[GlennUK]

My pleasure!