AutoSum in Word tables

AutoSum in Word tables

Postby jmt356 » 23 Feb 2011, 13:52

Autosum is a neat feature that can add figures in Word tables without needing to create a a separate Excel spreadsheet. But can it only add consecutive cells that have values in them? I have a table with 10 rows, and the 6th row is blank. The Autosum figure, which is in row 10, is only adding up rows 7-9. It only adds the values in Rows 1-5 when I put a 0 in row 6, but I want row 6 empty. For now, I'm putting a white zero in there that doesn't show up, but is there another solution?
Regards,

JMT
Post=43419
jmt356
5StarLounger
 
Posts: 1155
Joined: 28 Mar 2010, 01:49

Re: AutoSum in Word tables

Postby StuartR » 23 Feb 2011, 13:58

I assume that you are using a field with {=SUM(above) } to create the sum.
Assuming this is in the third column of the table try using
{=SUM(C1, C2, C3, C4, C5, C7, C8, C9) }
replace C with the correct letter for the table column you need
StuartR
Post=43422
User avatar
StuartR
Administrator
 
Posts: 6039
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: AutoSum in Word tables

Postby HansV » 23 Feb 2011, 14:15

In addition to Stuart's reply: the formula =SUM(ABOVE) is a convenient shortcut, but formulas in Word tables work more or less the same as in Excel. The formula =SUM(C1:C9) will sum the cells in the 3rd column (C) from the 1st to the 9th row, ignoring empty cells and text values.
Unlike Excel, Word does not automatically adjust such a formula when you copy it to another column - you have to adjust it manually.
Regards,
Hans
Post=43423
User avatar
HansV
Clever Clogs
 
Posts: 33352
Joined: 16 Jan 2010, 00:14
Location: Leiden, The Netherlands

Re: AutoSum in Word tables

Postby jmt356 » 23 Feb 2011, 15:06

{=SUM(ABOVE)} is the default formula that Word was using to count the cells, but the fact that one of the cellls had no value in it caused the formula to omit the figures in the cells above the empty cell. However, the formula {=SUM(C1:C9)} worked in capturing all of the values together even though one of the cells was blank.
Regards,

JMT
Post=43430
jmt356
5StarLounger
 
Posts: 1155
Joined: 28 Mar 2010, 01:49

Re: AutoSum in Word tables

Postby StuartR » 23 Feb 2011, 15:41

Good to hear you have a solution thank you for letting us know.
StuartR
Post=43437
User avatar
StuartR
Administrator
 
Posts: 6039
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: AutoSum in Word tables

Postby jmt356 » 23 Feb 2011, 16:26

Just 1 more quick question: why is Word automatically inserting a decimal point and two zeros to the right of it? It obviously recognized that the values in the cells being added were referring to dollars, since they had dollar signs next to them, and it automatically added a dollar sign next to the figure, and I don't mind that, but how can I get it to remove the decimal point and two zeros?
Regards,

JMT
Post=43450
jmt356
5StarLounger
 
Posts: 1155
Joined: 28 Mar 2010, 01:49

Re: AutoSum in Word tables

Postby HansV » 23 Feb 2011, 16:58

Right-click the formula and select Toggle Field Codes from the popup menu. Is there a format switch after the SUM(...) formula?
Regards,
Hans
Post=43455
User avatar
HansV
Clever Clogs
 
Posts: 33352
Joined: 16 Jan 2010, 00:14
Location: Leiden, The Netherlands

Re: AutoSum in Word tables

Postby ChrisGreaves » 04 Mar 2011, 20:34

jmt356 wrote:Autosum is a neat feature that can ...
... act as a shortcut for formatting strings.
In my case the user (me!) had typed in track numbers, but the developer (me!) really wished they'd been keyed in as 3-digit strings:-
2.png
You do not have the required permissions to view the files attached to this post.
Superlatives are the hardest things in the world to justify.
Post=44261
User avatar
ChrisGreaves
PlatinumLounger
 
Posts: 4816
Joined: 24 Jan 2010, 23:23
Location: Yilgarn region of Toronto, Ontario, Canada


Return to Word

Who is online

Users browsing this forum: CCBot [Bot] and 0 guests