fonction SI

New Contributor

Bonjour, comment peux-t-on éventuellement simplifier la fonction suivante :


et éventuellement l'étendre aux ligne 4 à 22 ?


5 Replies

@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.

Thank you very much@Riny_van_Eekelen , it is very nice.


best response confirmed by Alain8 (New Contributor)


As variant

Thank you Sergei, COUNTA doesn't work but NBVAL works very well.


That's why I attached the file to previous post. If open it shows correct formula for the current locale.