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

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

desiya
15 ●2 ●2 ●7

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

Opaque
14331 ●3 ●26 ●107

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

Comments

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

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

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

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

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

Thanks for your response.

Please how do I do that?

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

Click the Edit link at the end of the title?

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

add a comment

2

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

Opaque
14331 ●3 ●26 ●107

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

Hello,

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

Hope that helps.

edit flag offensive delete link

Comments

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

Why can't I up vote you answer?

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

add a comment

2

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

igorlius
1067 ●2 ●13 ●19 http://userfriendly.org/

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

Hello,

i think you are looking for the SUMIF function

image description

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

edit flag offensive delete link

Comments

Thanks a million. It worked.

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

Why can't I up vote your answer?

desiya ( 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.

igorlius ( 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?

desiya ( 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.

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

add a comment

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

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

Comments

2 Answers

Comments

Comments

Question Tools

Stats

Related questions

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

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

Comments

2 Answers

Comments

Comments

Question Tools

Stats

Related questions

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

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