=SOMME(DECALER($B$2;;;NBVAL(B:B)-1))/(NBVAL(B:B)-1)
Bonjour à tous,
A essayer:
Code:=SOMME(DECALER($B$2;;;NBVAL(B:B)-1))/(NBVAL(B:B)-1)
JHA
=SOMME(INDIRECT("B2:B"&NB.SI(B:B;">0")))/(NB.SI(B:B;">0")-1)
=SOMME(INDIRECT("B2:B"&NB.SI(B$2:B$1048576;">0%")+1))/(NB.SI(B$2:B$1048576;">0"))
=SOMME(DECALER($B$2;;;NBVAL(B2:B100)))/(NBVAL(B2:B100))