Ask Your Question

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

asked 2020-09-01 13:06:24 +0100

desiya gravatar image

updated 2020-09-01 13:28:28 +0100

Opaque gravatar image

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 flag offensive 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).
  2. it gives us more informations about your problem.
Zizi64 gravatar imageZizi64 ( 2020-09-01 13:13:13 +0100 )edit

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

gabix gravatar imagegabix ( 2020-09-01 13:20:55 +0100 )edit

Thanks for your response.

Please how do I do that?

desiya gravatar imagedesiya ( 2020-09-01 13:20:56 +0100 )edit

Click the Edit link at the end of the title?

robleyd gravatar imagerobleyd ( 2020-09-01 13:27:40 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2020-09-01 13:25:48 +0100

Opaque gravatar image

updated 2020-09-01 13:33:45 +0100


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

Hope that helps.

edit flag offensive delete link 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.

desiya gravatar imagedesiya ( 2020-09-01 13:36:54 +0100 )edit

Why can't I up vote you answer?

desiya gravatar imagedesiya ( 2020-09-01 13:37:30 +0100 )edit

answered 2020-09-01 13:21:40 +0100

igorlius gravatar image

updated 2020-09-01 13:29:31 +0100


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

edit flag offensive delete link more


Thanks a million. It worked.

desiya gravatar imagedesiya ( 2020-09-01 13:35:51 +0100 )edit

Why can't I up vote your answer?

desiya gravatar imagedesiya ( 2020-09-01 13:37:54 +0100 )edit

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

igorlius gravatar imageigorlius ( 2020-09-01 13:40:13 +0100 )edit

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

desiya gravatar imagedesiya ( 2020-09-01 13:46:00 +0100 )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.

igorlius gravatar imageigorlius ( 2020-09-01 13:55:02 +0100 )edit

Question Tools

1 follower


Asked: 2020-09-01 13:06:24 +0100

Seen: 556 times

Last updated: Sep 01 '20