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

English
, , , ,
#1

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.
Your achievements with Visual BASIC coding in LO
#2

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.
#3

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

#4

Thanks for your response.

Please how do I do that?

#5

Click the Edit link at the end of the title?

#6

Hello,

i think you are looking for the SUMIF function

image description

Take a look here
https://help.libreoffice.org/6.1/en-US/text/scalc/01/04060106.html?&DbPAR=CALC&System=UNIX#Section15

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

#7

Thanks a million. It worked.

#8

Why can’t I up vote your answer?

#9

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

#10

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

#11

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.

#12

Hello,

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

Hope that helps.

#13

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.

#14

Why can’t I up vote you answer?

#15

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.