Nov 07 2021 05:25 AM
Bonjour, comment peux-t-on éventuellement simplifier la fonction suivante :
=SI(B4="";"";A4)+SI(C4="";"0";A4)+SI(D4="";"0";A4)+SI(E4="";"0";A4)
et éventuellement l'étendre aux ligne 4 à 22 ?
Merci
Nov 07 2021 05:39 AM
@Alain8 Started changing the original formula until I realized you asked for a simplification. Have a look at the attached file where I used SUMPRODUCT. It should come out in French when you open the workbook.
Nov 07 2021 08:42 AM
SolutionNov 07 2021 11:59 PM
Nov 08 2021 02:07 PM
That's why I attached the file to previous post. If open it shows correct formula for the current locale.
Nov 07 2021 08:42 AM
Solution