1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| Sub moy_good()
'Range("C17").FormulaArray = "=SUMIF(GOOD!C[-1],RC[-1],GOOD!C[1])/COUNTIF(GOOD!C[-1],RC[-1])"
'Range("D17").FormulaArray = "=SUMIF(GOOD!C[-2],RC[-2],GOOD!C[2])/COUNTIF(GOOD!C[-2],RC[-2])"
'Range("E17").FormulaArray = "=SUMIF(GOOD!C[-3],RC[-3],GOOD!C[3])/COUNTIF(GOOD!C[-3],RC[-3])"
'Range("F17").FormulaArray = "=SUMIF(GOOD!C[-4],RC[-4],GOOD!C[4])/COUNTIF(GOOD!C[-4],RC[-4])"
'Range("G17").FormulaArray = "=SUMIF(GOOD!C[-5],RC[-5],GOOD!C[6])/COUNTIF(GOOD!C[-5],RC[-5])"
'etc..................
Dim X As Long
Dim Y As Integer
For X = 17 To 25
For Y = 1 To 5
Cells(X, Y + 2) = "=SUMIF(GOOD!C[" & -Y & "],RC[" & -Y & "],GOOD!C[" & IIf(Y = 5, 6, Y) & "])/COUNTIF(GOOD!C[" & -Y & "],RC[" & -Y & "])"
Next Y
Next X
End Sub |
Partager