SUMIF formula returning negative value & I need it to be positive

Hello, I found this formula on the internet and changed it for my purpose:

=SUMIF($M:$M,"="&"D",$F:$F)+SUMIF($M:$M,"="&"A",$F:$F)-SUMIF($N:$N,"<>""0")-$H$3

The value it returns is correct, except that it is a negative and I need it to be a positive. The numbers in column M are actually negatives that I'm adding together in the first 2 SUMIF statements. The numbers in column N are positive and the number in cell H3 is positive. So, taking in consideration of the SUMIF conditions of my formula, I really need the formula to work this way:

Cell H3 - Column M + Column N

I have tried several variations of *-1 with the $H$3 cell reference at the end of the formula (to change the polarity) and the result remains a negative or it returns a positive with an incorrect dollar amount.

I have a visual basic code that will reverse the "polarity" but I was hoping there a way to modify my formula to do that.

I hope this makes sense and that I have provided enough infomation. Please let me know if you need additional information.

Thanks!

Debbie

Hi, Trevor. THAT IS IT! I knew it was something very simple - the negative added to the front of the formula! I'm not that good with formulas but I can usually find what I need by searching the internet.

Hi, Jeffrey. Thank you for the welcome and suggestion! I DID try ABS but again, I am not that good with formulas and couldn't figure out how to work it into my formula.

Thank you both for your help and suggestions!!

And thank you for your suggestion too, Daddylonglegs!

You guys are awesome!!

Originally Posted by martindwilson

SUMIF($N:$N,"<>""0")????? surely thats just sum($N:$N)

Yes, Martin, I did realize that was "dumb" but I'm not good at creating formulas so I copied it from the internet and once it gave me the total I needed, I kinda stopped changing it, except for the polarity problem. Thanks for confirming that.

Originally Posted by dosbirn

Now I need to insert the formula into a VBA module. This doesn't seem to work:

Range("D7").Formula = "=-(SUMIF($M:$M,"="&"D",$F:$F)+SUMIF($M:$M,"="&"A",$F:$F)-SUM($N:$N)-$H$3)"

I'm not sure if the above post was missed because I posted another after it.

I even tried using Daddylonglegs' suggested formula below (which also works in the spreadsheet).

Range ("D7").formula = "=SUMIF($N:$N,"<>0")+$H$3-SUM(SUMIF($M:$M,{"A","D"},$F:$F))"

Is it too difficult to add a formula (in this way) to a module? Does it need to be converted into code instead?

I'm sorry but I have limited experience with Excel formulas and VBA.

You rock, Martin! That worked! Thank you so much.

Whew! Now I should be able to close this thread and move on to tackle to the next issue I run across. hahaha

Originally Posted by TMShucks

Thanks for the rep.

YW....but thank YOU for your help!