[Solved] Sum cells in a range with specific values

[Synthex]

What is formula to sum the values in a range that meet specific criteria: I need to sum numbers that have negatuve values -0,10 and -0,38.
I tried SUMIF function to sum the values, but this don't works:

Code: Select all

=SUMIF(F5:F60; "-0,10; -0,38")

[MrProgrammer]

I need to sum numbers that have negatuve values -0,10 and -0,38.

[Tutorial] The SUMPRODUCT function

If your post meant that you want to sum every negative value.
=SUMPRODUCT(F5:F60;F5:F60<0)

If you meant that you want to sum only those two specific values, ignoring any other negative values, use:
=SUMPRODUCT(F5:F60;F5:F60=-10E-2)+SUMPRODUCT(F5:F60;F5:F60=-38E-2)    or
=SUMPRODUCT(F5:F60=-10E-2)*-10E-2+SUMPRODUCT(F5:F60=-38E-2)*-38E-2
The first sums those two values in the range. The second multiplies your two values by their counts in the range.

If you need any additional assistance attach a spreadsheet demonstrating the difficulty (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the spreadsheet itself). I will not help further unless you attach.

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

[Synthex]

If you meant that you want to sum only those two specific values, ignoring any other negative values, use:
=SUMPRODUCT(F5:F60;F5:F60=-10E-2)+SUMPRODUCT(F5:F60;F5:F60=-38E-2)    or
=SUMPRODUCT(F5:F60=-10E-2)*-10E-2+SUMPRODUCT(F5:F60=-38E-2)*-38E-2

I meant second case. It works, Thank you.