View original (French)

Sum only the positive numbers in a column

Pol -  
ccm81 Posted messages 11033 Status Member -
Hello,
I want to only add the positive numbers from a column; the negatives will not be taken into account.
Thank you

Configuration: Macintosh / Firefox 63.0

1 answer

  1.
    ccm81 Posted messages 11033 Status Member 2 434
     
    Hello

    Your values in A2:A10
    The formula (excel)
    =SUMIF($A$2:$A$10,">0")

    Best regards
    3