How to sum only cells with negative values in a column?

Hi everyone!

How do i select and sum only the cells with negative values in a column?

My first question and I am totally new to spreadsheet (of what ever brand but I choosed Libre).

My question.

How do i select and sum only the cells with negative values in a column?

Screenshot from 2020-09-01 11-53-27.png

In the picture above, I want the total sum of cells with negative values in column “C” (that is C18 and C28 “-8800 and -9800 which is -18600”) to be inserted in cell “I12”.

How do I achieve this?

Thanks in anticipation.

Meanwhile I got the spreadsheet (about 8 sheets so far) done this far by getting answers here; please don’t fail me on this one as I could not find answer to this particular challenge.

**[Edit - Opaque]** Shortened title and moved the text to details.

Always better to upload a real ODF type sample file instead of a static picture. A real document file

  1. smaller than a picture file (usually).
  2. it gives us more informations about your problem.

Read these guidelines and ask a good question. In particular, make the title short.

Thanks for your response.

Please how do I do that?

Click the Edit link at the end of the title?


i think you are looking for the SUMIF function

image description

Take a look here

Hope that helps.

To show the community your question has been answered, click the ✓ next to the correct answer, and “upvote” by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!

Have a nice day and let’s (continue to) “Be excellent to each other!”

Thanks a million. It worked.

Why can’t I up vote your answer?

You need a bit of karma to upvote, i upvoted your question, so you should be able to vote on answers now.

Upvote works now, How did you add the picture and how can I mark this as solved?

Thanks for the vote.
In questions and answers there should be a edit button to upload images, Not sure if there is also a karma requirement for it to be usable/present. You can hover over your karma (right of you username and see what you are allowed/capable of doing)
Have a nice day.


use: SUMIF(C6:C28;"<0";C6:C28)

Hope that helps.

You nailed it… I would have shown you a screenshot but I can’t find a way to add picture to comment. Thanks a million.

Why can’t I up vote you answer?