|
|
|
|
#1
12-19-2023, 11:09 AM
|
|||
|
|||
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. 
|
|
#2
12-19-2023, 08:15 PM
|
|||
|
|||
|
You could use the ABS function.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel 2019: How to display the sign of numbers in another field in brackets? | Jamal NUMAN | Excel | 3 | 09-16-2021 09:44 AM |
| Merging phone numbers with + sign | WibbleWobble | Mail Merge | 2 | 12-28-2019 04:29 AM |
| Activate (show) a Drop-down form field when another drop-down form field is selected from | Jentis | Word VBA | 1 | 04-19-2018 09:42 PM |
 Macro to autofill a form field ONLY if the form field is blank upon entry
|
Pindar | Word VBA | 2 | 01-12-2017 05:03 PM |
|
How to add the plus sign (+) automatically for the numbers which are positive?
|
Jamal NUMAN | Excel | 2 | 05-01-2011 03:15 PM |
Windows 10 
Office 2007
Hybrid Mode