=SOMME.SI(B1:L1;"WE";A1:K1)
=SOMME.SI(B1:L1;"WE";A1:K1)&" WE"&" + "&SOMME.SI(B1:L1;"JVF";A1:K1)&" JVF"
Function Vac()
Dim i, j&, c&
Application.Volatile
j = [XFD1].End(xlToLeft).Column
For c = 1 To j Step 2
Debug.Print Cells(1, c) & " " & Cells(1, c + 1) & " + "
If Cells(1, c) <> 0 Then i = i & Cells(1, c) & " " & Cells(1, c + 1) & " + "
Next
Vac = Left(i, Len(i) - 2)
End Function
quelle buse je suis!!
Fichier joint...
Function Vac(Zone As Range)
Dim i, j&, c&
Application.Volatile
j = Zone.Row
For c = 1 To 12 Step 2
Debug.Print Cells(1, c) & " " & Cells(1, c + 1) & " + "
If Cells(j, c) <> 0 Then i = i & Cells(j, c) & " " & Cells(j, c + 1) & " + "
Next
If i <> "" Then Vac = Left(i, Len(i) - 2) Else: Vac = ""
End Function