SUMIF that will yield negative values, but not positive values.

[franciscodisco9]

I have a spreadsheet where I am trying to locate negative values and add in the difference of the cells in Buffer A (Col C) and Buffer B (Col D).
I only want this function to return values that yield negative values (Examples of these are highlighted in orange. I don't want to yield positive values (Highlighted in blue).

The results that I want returned are highlighted in green in Column 'N'.

 

[Joe4]

Welcome to the Board!

Not sure if you attempted to post an image, but if you did, it did not work.
If you would like to, try using the tool mentioned here: XL2BB - Excel Range to BBCode

 

[franciscodisco9]

I have a spreadsheet where I am trying to locate negative values and add in the difference of the cells in Buffer A (Col C) and Buffer B (Col D).
I only want this function to return values that yield negative values (Examples of these are highlighted in orange. I don't want to yield positive values (Highlighted in blue).

The results that I want returned are highlighted in green in Column 'N'.

I currently have this formula "=IF(OR(COUNTIF(G3:L3,0)=6,COUNTIF(G3:L3,">"&0)),"",SUM(G3:L3)+(C2-D2))".

However, this yields the values that are listed in Column 'M'. I only want the negative values. (Highlighted in green in Column 'N').

 

[etaf]

no example
=SUMIF(C2:C100,"<"&0,C2:C100)
Will only sum negative values
NOT sure about comments on Buffer A or B

 

[franciscodisco9]

Posted a reply that has an image attached onto it.

 

[Tetra201]

Same topic on another forum.

 

[etaf]

not really sure i understand what you are doing to get to those numbers

 

[Joe4]

Same topic on another forum.

Posting the same question on multiple forums is known as Cross-Posting. While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Please follow these guidelines in the future.