# How to sum only cells with negative values in a column? [closed]

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?

C:\fakepath\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.

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by igorlius close date 2020-09-06 19:04:51.821339

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).
( 2020-09-01 13:13:13 +0200 )edit

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

( 2020-09-01 13:20:55 +0200 )edit

Please how do I do that?

( 2020-09-01 13:20:56 +0200 )edit

Click the Edit link at the end of the title?

( 2020-09-01 13:27:40 +0200 )edit

Sort by » oldest newest most voted

Hello,

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

Hope that helps.

more

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.

( 2020-09-01 13:36:54 +0200 )edit

Why can't I up vote you answer?

( 2020-09-01 13:37:30 +0200 )edit

Hello,

i think you are looking for the SUMIF function

Take a look here https://help.libreoffice.org/6.1/en-U...

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!"

more

Thanks a million. It worked.

( 2020-09-01 13:35:51 +0200 )edit

( 2020-09-01 13:37:54 +0200 )edit

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

( 2020-09-01 13:40:13 +0200 )edit

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

( 2020-09-01 13:46:00 +0200 )edit

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.

( 2020-09-01 13:55:02 +0200 )edit