=SOMME.SI(D8:L8;"<1")/NB.SI(D8:L8;"<1")
Function MoySpc(r As Range)
Dim Cel As Range, i&, s#
For Each Cel In r.Cells
If Cel.NumberFormat = "0%" Then i = i + 1: s = s + Cel.Value
Next
If i Then MoySpc = s / i Else MoySpc = ""
End Function
=MoySpc(D8:L8)
Function MoySpc(r As Range)
Application.Volatile
Dim Cel As Range, i&, s#
For Each Cel In r.Cells
If Cel.NumberFormat = "0%" And Not IsEmpty(Cel) Then i = i + 1: s = s + Cel.Value
Next
If i Then MoySpc = s / i Else MoySpc = ""
End Function