Sum of numbers regardless of sign in a Form Field
Hello. I have a Form Field table in Word and I'm trying to add up the total of the 3 fields, regardless of the positive or negative. In other words, I need -2000 and +2000 to equal 4,000. I have a formula that results in 0, which is my "net" but I need the "gross" if that makes sense. I tried using the "SUMIF" formula but could not get it to work properly.
I attached a sample that hopefully better explains it. Thank you in advance for any help.
|