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.
Always better to upload a real ODF type sample file instead of a static picture. A real document file
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?