4
I want to add the value (and show in any cell) of the Cx cell when Dx equals 1 and add the Cy values 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 row) to go to L3 and so L3 to have the sum of all the values of column C that has 1 in column D.
3
The formula for L3:
=SUMIF(D5:D9;"=1";C5:C9)
Translated SOMASE as @Isac said, if you’re not using function names in English.
Tools -> Options -> Libreoffice Calc -> Formula -> Use function names in English.
Documentation: https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_SUMIF_function
Browser other questions tagged excel libreoffice
You are not signed in. Login or sign up in order to post.
The closure of this question is being discussed at the goal
– user28595