Link to home
Start Free TrialLog in
Avatar of Need -a- Clue
Need -a- ClueFlag for United States of America

asked on

SUM COLUMN IN WORD??

I have a small table in Word 07. One column is numbers only. Can I insert a field at the bottom of the column that sums the above selected numbers?
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

Yes

{= SUM (ABOVE) }
Note that you also use Excel-like numbering:

{ = SUM (A1:A6) }
Avatar of Need -a- Clue

ASKER

GrahamSkan, thanks. Where do I put that formula? I have 15 rows. In column 4 I have all the numbers. How do I implement the formula you mention? I have not designated any cells, columns or rows anything special. I just drew the table and entered the data.
Put it in the bottom row under appropriate the column. If last row already has data, then add another row.
You don't have to label the cells in any way.

GrahamSkan, it is not working for me. I am making sure that every cell in the column has a numeric digit in it. I have an empty row. I paste your formula into the open cell at the bottom of the column I want to sum. No sum shows up. Only the formula remains in that cell. What am I missing?
Avatar of ashishgamre11
ashishgamre11

I think you have 16*4 table (i.e. 16 rows and 4 columns)
You want to add the data columnwise.
Add a button in the document and onclick event add the data.
You can use the following code:

Private Sub CommandButton1_Click()
Tables(1).Cell(16, 2).AutoSum
Tables(1).Cell(16, 3).AutoSum
End Sub



table before executing the code:

      1      1
      2      2
      3      3
      4      4
      5      5
      6      67
      7      5
      8      3
      9      21
      1      6
      2      34
      3      54
      4      67
      5      32
      64      4

Table after executing the code:
      1      1
      2      2
      3      3
      4      4
      5      5
      6      67
      7      5
      8      3
      9      21
      1      6
      2      34
      3      54
      4      67
      5      32
      64      4
      124  308


THE FIRST AND LAST COLUMNS OF THE ABOVE TABLE ARE BLANK ARE LEFT BLANK.
SEARCH ABOUT "AutoSum" on internet.

I think it will be helpful to you.
I will try that, however (don't get ticked at me), how does one create or add a "button". Word help does not tell me this.
You can't paste the formula in, unless you have already copied it into the clipboard from another Word document. It is a field, and the {} pairs are not the actual keyboard characters (shifted []). They must be entered, either by inserting a field, of or an insert an empty field with Ctrl+F9 and typing the text in between. You will see the the {} symbols are surrounded by dots, to indicate that they are not the {} characters.

FYI

Alt+F9  toggles between displaying field results and field code in the whole document.
F9        updates the field results
ASKER CERTIFIED SOLUTION
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you! I feel confident that after studying and trying combinations of your suggestions that I will get it to work for me. Points Awarded and much deserved. I'll post again if I cannot gett it to work. In fact, I'm posting another simple question right now.
Thank you.

Sorry it was more difficult for you than I first guessed, but those who want to learn are the main target of this site and your user name embodies the spirit of this forum