View original (French)

Empty cell in OpenOffice Calc

Solved
olivier -  
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   -
Bonjour,
sous OpenOffice Calc, pour écrire "vide" dans le critère de la fonction SOMME.SI, vous pouvez utiliser la fonction suivante :
=SOMME.SI(E3:E87;"";F3:F87)
Cela devrait fonctionner comme vous le souhaitez.

Merci
a+
Configuration: Windows 8 / Chrome 33.0.1750.146

1 answer

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    besides circumventing the difficulty with a trick:
    =SUM(F3:F87)-SUMIF(E3:E87,"<>" ,F3:F87)
    best regards

    ps or try with:
    =SUMIF(E3:E87,"<>0",F3:F87)

    To err is human, to persist (in error) is diabolical.
    0
    1. olivier
       
      Thank you, the result of your formula is good.
      Quick and effective Vaucluse!
      See you soon, I think!
      0
    2. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      Safe travels, I'm marking the topic as resolved
      sincerely
      0