Say your 6 numbers a to f are in cells A1 to F1.

N can be calculated as a formula, say in G1, =COUNTIF(A1:F1,"<>0")

Then your final answer can be calculated as a formula, say in H1,

=(SUM(A1:F1)/G1)*(6/G1)

Note that this expression can be simplified to:

=(SUM(A1:F1)*6)/G1

Also note, if N is zero then you will get a division by zero error, so you

might want to trap that by using a modified formula for your final expression:

IF(G1=0,"N = zero",(SUM(A1:F1)*6)/G1)

Regards,

Tom