Word table formula for subtraction

jmt356
SilverLounger
Posts: 2371
Joined: 28 Mar 2010, 01:49

Word table formula for subtraction

Post by jmt356 »

{=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?
Regards,

JMT

User avatar
StuartR
Administrator
Posts: 12577
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: Word table formula for subtraction

Post by StuartR »

If you're in column D of the table then try {=D1*2-SUM(ABOVE), replace D with the correct column
StuartR


User avatar
macropod
4StarLounger
Posts: 508
Joined: 17 Dec 2010, 03:14

Re: Word table formula for subtraction

Post by macropod »

jmt356 wrote:
20 Mar 2021, 19:01
{=SUM(ABOVE)} is a formula that will add up all of the numbers in cells above the formula.
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
jmt356 wrote:
20 Mar 2021, 19:01
What is the formula to subtract all of the numbers in cells above the formula from the number in the first row?
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]