• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to get the sum of negative value

Status
Not open for further replies.

sachar

Member
Dear All,

With reference to the attach a sample file, is there any formula to get the sum of the only negative value of the total rows as I got the answer in cell “B20” by manual calculation.

Thanking you.
 

Attachments

  • example file_sumif formula.xlsx
    14.5 KB · Views: 3
Status
Not open for further replies.
Back
Top