How to get values in function of another value?

Navigation
4

I want to sum the value (and show in any cell) of the cell Cx when Dx is equal to 1 and add the values of Cy when Dy is 2.

For example: In the photo, when the value of cell Dx is 1, I want the value of Cx (of the same line) to go to L3 and thus L3 have the sum of all values of column C that has 1 in column D.

    
asked by anonymous 17.03.2018 / 00:08

1 answer

3

The formula for L3 : 

=SUMIF(D5:D9;"=1";C5:C9)

Translated SOMASE as @Isac said, if you are not using English function names.
Tools - > Options - > LibreOffice Calc - > Formula - > Use function names in English.

Documentation: link

    
17.03.2018 / 15:32
Shows the wrong date Return default value if there is no record