If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
How do I sum a column in a table in Word 2007?
Not false - merely incomplete. However the answer completely addressed the
question that was asked ... in July 2007! -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "VAUTOUR 110" wrote in message ... ALl above explanations are false - if there are blank fields interspersed within the column to be summed-up. In that case, one needs to position the cursor in each blank field and calling the SUM(ABOVE). Then adding individually all the SUM(ABOVE)s. "Graham Mayor" wrote: If there are amounts to sum in the column above the cell in which you want to insert the total, clicking the formula button with the cursor in that cell will offer to insert the =Sum(Above) by default. Hardly rocket science. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org macropod wrote: Hi, With the table cell where you want the sum to appear selected, click on the table 'Layout' Ribbon tab, then click the formula icon and type in your forumla (eg =SUM(ABOVE) or =SUM(A1:A5), or whatever else it is you need) and add the appropriate numeric formatting switch from the dropdown. Not at all difficult, really. "P.O.'d with Microsoft" P.O.'d with wrote in message ... I still can't get it to work!!! I loved Wordperfect, but gave it up with my new Vista PC because I had to replace almost ALL my software- at great expense (but that's another matter). What I CAN'T BELIEVE is that Microsoft has decided that summing a column in Word is not one of the most normal and NECESSARY functions. I KNOW that I could remake my invoices to use Excell instead - but WHY SHOULD I HAVE TO?? It is enough to make me decide to discard MS Office altogether. I was happier with WordPerfect and Quattrro!! and if all the $!%$@! thing needs is ONE SUM, why should I convert it? Even the latest AutoCAD software has annoying features (or lack of them) in Vista. "Rick@#$*!" wrote: Thanks Summer and Rick both helpful replies. "Graham Mayor" wrote: Or with the cursor in the cell where you want the calculation, Insert Quick Parts Field = (Formula field) and again =Sum(Above) will be the default. Note that with 'Summer's' method, the cursor has to be in the table for the layout tab to appear on the ribbon. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Summer wrote: If you have a column row with figures tab to next row and move to column you wish to Sum (there should already be at least one amount say "10" in the Sum column. Press Insert Layout Formula (end of ribbon) {= SUM(ABOVE } will appear Press ALT F9 to toggle this code view. Hope this helps. "Rick@#$*!" wrote in message ... How do I sum a column in a table in Word 2007? New-fangled version is toooo complicated.... |
|
Thread Tools | |
Display Modes | |
|
|