Bonjour,
voici une solution avec 2 function perso,
Function AdditionOnglet(onglet As String, critere As String) As Double
Dim t As Double, sh, add1 As String, add2 As String, i As Integer
Set sh = Sheets(onglet)
For i = 2 To 25 Step 2
add1 = Range(Cells(8, i), Cells(161, i)).Address
add2 = Range(Cells(8, i + 1), Cells(161, i + 1)).Address
AdditionOnglet = AdditionOnglet + Application.SumIf(sh.Range(add1), critere, sh.Range(add2))
Next i
End Function
Function NombreOnglet(onglet As String, critere As String) As Double
Dim t As Double, sh, add1 As String, i As Integer
Set sh = Sheets(onglet)
For i = 2 To 25 Step 2
add1 = Range(Cells(8, i), Cells(161, i)).Address
NombreOnglet = NombreOnglet + Application.CountIf(sh.Range(add1), critere)
Next i
End Function