unable to use SUM.IF function : the sum of values for the range selected is always nil

Occasional Visitor


I wish to calculate the sum of cells which have the item "RETRAIT" in the description column, but I keep getting "0" as the result.

I do utilise the SUM.IF function this way : SUM.IF(B2:B23;"RETRAIT";D2:D23). there are only negative values in the D2:D23 range, so I should get a larger negative sum, but instead I get zero...


Never used the SUM.IF function before, I must do something wrong, obviously...


thank you for your help !

0 Replies