# 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?
###### Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RetiredCommented:
Yes

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

{ = SUM (A1:A6) }
0
RESEARCHERAuthor Commented:
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.
0
RetiredCommented:
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.
0
RESEARCHERAuthor Commented:

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?
0
Commented:
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.
0
RESEARCHERAuthor Commented:
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.
0
RetiredCommented:
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
0
RetiredCommented:
Oops.

", of or an insert an empty field"

", or by inserting an empty field"
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

RESEARCHERAuthor Commented:
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.
0
RetiredCommented:
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
0
###### It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Word

From novice to tech pro — start learning today.