j = j + 1 And k = Feuil2.Range("M" & i).Value + k
j = j + 1 And k = Feuil2.Range("M" & i).Value + k
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionIf Feuil2.Range("G" & i).Value = 1 Then
j = j + 1 And k = Feuil2.Range("M" & i).Value + k
Feuil5.Range("B5").Value = Round((k / j), 2)
j = j + 1 And k = Feuil2.Range("M" & i).Value + k
Feuil5.Range("B5").Value = Round((k / j), 2)
j = j + 1 k = Feuil2.Range("M" & i).Value + k
debug.print "k = " & k debug.print "j = " & j Feuil5.Range("B5").Value = Round((k / j), 2)
Feuil2.Range("G" & i).Value = 1 Then
if j>0 then Feuil5.Range("B5").Value = Round((k / j), 2) else Debug.print "J = 0 " End if
if not toto is nothing, then titi = WorkSheetFunction.Average(toto)
Sub MoyenneSI() On Error Resume Next MoySi = WorksheetFunction.AverageIf(Columns(7), 1, Columns(13)) If Err <> 0 Then MsgBox "Erreur" Else MsgBox MoySi End If End Sub
Sub MoyenneSiViaSommeprod() Plage1 = "G1:G10" Plage2 = "M1:M10" Mosi = Application.Evaluate("SUMPRODUCT((" & Plage1 & " = 1)*(" & Plage2 & "))/SUMPRODUCT((" & Plage1 & " = 1)*(1))") Debug.Print Mosi End Sub