Forum Discussion

Alain8's avatar
Alain8
Copper Contributor
Nov 07, 2021
Solved

fonction SI

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...
excel
  • Alain8's avatar
    Alain8
    Copper Contributor
    Nov 07, 2021
    Thank you Sergei, COUNTA doesn't work but NBVAL works very well. 👍
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 08, 2021

      Alain8 

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

Resources