{=SUM(ABOVE)} is a formula that will add up all of the numbers in cells above the formula.
What is the formula to subtract all of the numbers in cells above the formula from the number in the first row?
Word table formula for subtraction
-
- SilverLounger
- Posts: 2371
- Joined: 28 Mar 2010, 01:49
Word table formula for subtraction
Regards,
JMT
JMT
-
- Administrator
- Posts: 12577
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: Word table formula for subtraction
If you're in column D of the table then try {=D1*2-SUM(ABOVE), replace D with the correct column
StuartR
-
- 4StarLounger
- Posts: 508
- Joined: 17 Dec 2010, 03:14
Re: Word table formula for subtraction
Not reliably. See Referencing Adjacent Cells in a Row or Column in my Microsoft Word Field Maths Tutorial, at:
https://www.msofficeforums.com/word/387 ... orial.html
or:
http://www.gmayor.com/downloads.htm#Third_party
Essentially, it's the same formula as you'd use in Excel (e.g. = A1-SUM(A2-A4)), but in a formula field.
Paul Edstein
[Fmr MS MVP - Word]
[Fmr MS MVP - Word]