Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Samantha Samantha is offline
external usenet poster
 
Posts: 11
Default Automatically totaling a column in a table

I have a template in which I need the last column totaled. I cannot use the
atuo sum feature because not all of the rows will always be filled. I know I
can use the Tools Calculate feature, but since this form is going out to many
people, I was hoping that there would be a way to do it automatically, so
there is no chance of people forgetting how to do it. I cannot figure out
how to create a macro to do it for me.
  #2   Report Post  
Posted to microsoft.public.word.tables
BARRY BARRY is offline
external usenet poster
 
Posts: 64
Default Automatically totaling a column in a table

Hello, Samantha:

If by "auto sum feature", you mean the Sum function, you can use it to total
a partially filled in column of figures. I just tried it and it works fine.
Just select a numeric format from the "Number" tab of the "Format Cells"
dialog box and use the formula

=SUM(Xn:Xm)

where

"X" is the column number and
"n" and m are the start and end rows of your set of numbers.

The blank cells are simply treated as zeros. (SUM can handle rows,
discontinuous ranges and multiple ranges in a single formula.

HTH

--
Barry Carroll

(Cleverly disguised as a trained SW engineer.)
---------
Datalogic Scanning, Inc. assumes no responsibility whatsoever for any
statements made by me. I''m entirely on my own here.


"Samantha" wrote:

I have a template in which I need the last column totaled. I cannot use the
atuo sum feature because not all of the rows will always be filled. I know I
can use the Tools Calculate feature, but since this form is going out to many
people, I was hoping that there would be a way to do it automatically, so
there is no chance of people forgetting how to do it. I cannot figure out
how to create a macro to do it for me.

  #3   Report Post  
Posted to microsoft.public.word.tables
Samantha Samantha is offline
external usenet poster
 
Posts: 11
Default Automatically totaling a column in a table

When I try that it just says syntax error. I have calculations in the row
that I'm totaling, I'm not sure if that is effecting it at all.

"Barry" wrote:

Hello, Samantha:

If by "auto sum feature", you mean the Sum function, you can use it to total
a partially filled in column of figures. I just tried it and it works fine.
Just select a numeric format from the "Number" tab of the "Format Cells"
dialog box and use the formula

=SUM(Xn:Xm)

where

"X" is the column number and
"n" and m are the start and end rows of your set of numbers.

The blank cells are simply treated as zeros. (SUM can handle rows,
discontinuous ranges and multiple ranges in a single formula.

HTH

--
Barry Carroll

(Cleverly disguised as a trained SW engineer.)
---------
Datalogic Scanning, Inc. assumes no responsibility whatsoever for any
statements made by me. I''m entirely on my own here.


"Samantha" wrote:

I have a template in which I need the last column totaled. I cannot use the
atuo sum feature because not all of the rows will always be filled. I know I
can use the Tools Calculate feature, but since this form is going out to many
people, I was hoping that there would be a way to do it automatically, so
there is no chance of people forgetting how to do it. I cannot figure out
how to create a macro to do it for me.

  #4   Report Post  
Posted to microsoft.public.word.tables
BARRY BARRY is offline
external usenet poster
 
Posts: 64
Default Automatically totaling a column in a table

Forgive me, Samantha. The method I described in my previous post is for
Escel. I forgot we were talking about Word here.

Is it not possible or convenient to enter a zero into the otherwise blank
cells? If you did that, the Auto Sum feature would work, of course.

You could write a macro that would check each cell in the range. If it
found a number it would add it to the sum. If the cell were ampty (or held
anything other than a number), it would be skipped. This is not something
you can do by recording keystrokes, however; you would need to do some VB
programming. Besides, the result would be a macro, not unlike
Tools/Calculate of Auto Sum, which the user would have to activate after
entering the numbers.

If you really want to a column of numbers that automatically recalculats its
total when the user adds or changes its contents, then you should use Excel.
Is that a problem for you
--
Barry Carroll

(Cleverly disguised as a trained SW engineer.)
---------
Datalogic Scanning, Inc. assumes no responsibility whatsoever for any
statements made by me. I''m entirely on my own here.


"Barry" wrote:

Hello, Samantha:

If by "auto sum feature", you mean the Sum function, you can use it to total
a partially filled in column of figures. I just tried it and it works fine.
Just select a numeric format from the "Number" tab of the "Format Cells"
dialog box and use the formula

=SUM(Xn:Xm)

where

"X" is the column number and
"n" and m are the start and end rows of your set of numbers.

The blank cells are simply treated as zeros. (SUM can handle rows,
discontinuous ranges and multiple ranges in a single formula.

HTH

--
Barry Carroll

(Cleverly disguised as a trained SW engineer.)
---------
Datalogic Scanning, Inc. assumes no responsibility whatsoever for any
statements made by me. I''m entirely on my own here.


"Samantha" wrote:

I have a template in which I need the last column totaled. I cannot use the
atuo sum feature because not all of the rows will always be filled. I know I
can use the Tools Calculate feature, but since this form is going out to many
people, I was hoping that there would be a way to do it automatically, so
there is no chance of people forgetting how to do it. I cannot figure out
how to create a macro to do it for me.

  #5   Report Post  
Posted to microsoft.public.word.tables
Samantha Samantha is offline
external usenet poster
 
Posts: 11
Default Automatically totaling a column in a table

I don't know very mcuh about macros, but I think I remember reading something
about a macro button. I can't remember what it was, but if I was able to
create the macro and just have a button that they could push, I think that
would be easier for people to remember. The document is a PO that we're
sending to vendors, and it looks a little sloppy to have zeroes in the empty
cells, and we're trying to keep it in Word to stay similar to our other
templates. If i'm not able to do this, I'll just have everyone add the total
manually, I just thought it would be easier if I could do it for them.

"Barry" wrote:

Forgive me, Samantha. The method I described in my previous post is for
Escel. I forgot we were talking about Word here.

Is it not possible or convenient to enter a zero into the otherwise blank
cells? If you did that, the Auto Sum feature would work, of course.

You could write a macro that would check each cell in the range. If it
found a number it would add it to the sum. If the cell were ampty (or held
anything other than a number), it would be skipped. This is not something
you can do by recording keystrokes, however; you would need to do some VB
programming. Besides, the result would be a macro, not unlike
Tools/Calculate of Auto Sum, which the user would have to activate after
entering the numbers.

If you really want to a column of numbers that automatically recalculats its
total when the user adds or changes its contents, then you should use Excel.
Is that a problem for you
--
Barry Carroll

(Cleverly disguised as a trained SW engineer.)
---------
Datalogic Scanning, Inc. assumes no responsibility whatsoever for any
statements made by me. I''m entirely on my own here.


"Barry" wrote:

Hello, Samantha:

If by "auto sum feature", you mean the Sum function, you can use it to total
a partially filled in column of figures. I just tried it and it works fine.
Just select a numeric format from the "Number" tab of the "Format Cells"
dialog box and use the formula

=SUM(Xn:Xm)

where

"X" is the column number and
"n" and m are the start and end rows of your set of numbers.

The blank cells are simply treated as zeros. (SUM can handle rows,
discontinuous ranges and multiple ranges in a single formula.

HTH

--
Barry Carroll

(Cleverly disguised as a trained SW engineer.)
---------
Datalogic Scanning, Inc. assumes no responsibility whatsoever for any
statements made by me. I''m entirely on my own here.


"Samantha" wrote:

I have a template in which I need the last column totaled. I cannot use the
atuo sum feature because not all of the rows will always be filled. I know I
can use the Tools Calculate feature, but since this form is going out to many
people, I was hoping that there would be a way to do it automatically, so
there is no chance of people forgetting how to do it. I cannot figure out
how to create a macro to do it for me.



  #6   Report Post  
Posted to microsoft.public.word.tables
BARRY BARRY is offline
external usenet poster
 
Posts: 64
Default Automatically totaling a column in a table

Samantha:

I see. Well, as I said, I believe these things can be done. Unfortunately,
they are not trivial tasks. Wou would need a VBA programmer to write the
macro.

Fortunately, the Word Programming discussion group is full of VBA
programmers. Ask your question there and you may get more useful answers.

--
Barry Carroll

(Cleverly disguised as a trained SW engineer.)
---------
Datalogic Scanning, Inc. assumes no responsibility whatsoever for any
statements made by me. I''m entirely on my own here.


"Samantha" wrote:

I don't know very mcuh about macros, but I think I remember reading something
about a macro button. I can't remember what it was, but if I was able to
create the macro and just have a button that they could push, I think that
would be easier for people to remember. The document is a PO that we're
sending to vendors, and it looks a little sloppy to have zeroes in the empty
cells, and we're trying to keep it in Word to stay similar to our other
templates. If i'm not able to do this, I'll just have everyone add the total
manually, I just thought it would be easier if I could do it for them.

"Barry" wrote:

Forgive me, Samantha. The method I described in my previous post is for
Escel. I forgot we were talking about Word here.

Is it not possible or convenient to enter a zero into the otherwise blank
cells? If you did that, the Auto Sum feature would work, of course.

You could write a macro that would check each cell in the range. If it
found a number it would add it to the sum. If the cell were ampty (or held
anything other than a number), it would be skipped. This is not something
you can do by recording keystrokes, however; you would need to do some VB
programming. Besides, the result would be a macro, not unlike
Tools/Calculate of Auto Sum, which the user would have to activate after
entering the numbers.

If you really want to a column of numbers that automatically recalculats its
total when the user adds or changes its contents, then you should use Excel.
Is that a problem for you
--
Barry Carroll

(Cleverly disguised as a trained SW engineer.)
---------
Datalogic Scanning, Inc. assumes no responsibility whatsoever for any
statements made by me. I''m entirely on my own here.


"Barry" wrote:

Hello, Samantha:

If by "auto sum feature", you mean the Sum function, you can use it to total
a partially filled in column of figures. I just tried it and it works fine.
Just select a numeric format from the "Number" tab of the "Format Cells"
dialog box and use the formula

=SUM(Xn:Xm)

where

"X" is the column number and
"n" and m are the start and end rows of your set of numbers.

The blank cells are simply treated as zeros. (SUM can handle rows,
discontinuous ranges and multiple ranges in a single formula.

HTH

--
Barry Carroll

(Cleverly disguised as a trained SW engineer.)
---------
Datalogic Scanning, Inc. assumes no responsibility whatsoever for any
statements made by me. I''m entirely on my own here.


"Samantha" wrote:

I have a template in which I need the last column totaled. I cannot use the
atuo sum feature because not all of the rows will always be filled. I know I
can use the Tools Calculate feature, but since this form is going out to many
people, I was hoping that there would be a way to do it automatically, so
there is no chance of people forgetting how to do it. I cannot figure out
how to create a macro to do it for me.

  #7   Report Post  
Posted to microsoft.public.word.tables
Samantha Samantha is offline
external usenet poster
 
Posts: 11
Default Automatically totaling a column in a table

OK Thanks!

"Barry" wrote:

Samantha:

I see. Well, as I said, I believe these things can be done. Unfortunately,
they are not trivial tasks. Wou would need a VBA programmer to write the
macro.

Fortunately, the Word Programming discussion group is full of VBA
programmers. Ask your question there and you may get more useful answers.

--
Barry Carroll

(Cleverly disguised as a trained SW engineer.)
---------
Datalogic Scanning, Inc. assumes no responsibility whatsoever for any
statements made by me. I''m entirely on my own here.


"Samantha" wrote:

I don't know very mcuh about macros, but I think I remember reading something
about a macro button. I can't remember what it was, but if I was able to
create the macro and just have a button that they could push, I think that
would be easier for people to remember. The document is a PO that we're
sending to vendors, and it looks a little sloppy to have zeroes in the empty
cells, and we're trying to keep it in Word to stay similar to our other
templates. If i'm not able to do this, I'll just have everyone add the total
manually, I just thought it would be easier if I could do it for them.

"Barry" wrote:

Forgive me, Samantha. The method I described in my previous post is for
Escel. I forgot we were talking about Word here.

Is it not possible or convenient to enter a zero into the otherwise blank
cells? If you did that, the Auto Sum feature would work, of course.

You could write a macro that would check each cell in the range. If it
found a number it would add it to the sum. If the cell were ampty (or held
anything other than a number), it would be skipped. This is not something
you can do by recording keystrokes, however; you would need to do some VB
programming. Besides, the result would be a macro, not unlike
Tools/Calculate of Auto Sum, which the user would have to activate after
entering the numbers.

If you really want to a column of numbers that automatically recalculats its
total when the user adds or changes its contents, then you should use Excel.
Is that a problem for you
--
Barry Carroll

(Cleverly disguised as a trained SW engineer.)
---------
Datalogic Scanning, Inc. assumes no responsibility whatsoever for any
statements made by me. I''m entirely on my own here.


"Barry" wrote:

Hello, Samantha:

If by "auto sum feature", you mean the Sum function, you can use it to total
a partially filled in column of figures. I just tried it and it works fine.
Just select a numeric format from the "Number" tab of the "Format Cells"
dialog box and use the formula

=SUM(Xn:Xm)

where

"X" is the column number and
"n" and m are the start and end rows of your set of numbers.

The blank cells are simply treated as zeros. (SUM can handle rows,
discontinuous ranges and multiple ranges in a single formula.

HTH

--
Barry Carroll

(Cleverly disguised as a trained SW engineer.)
---------
Datalogic Scanning, Inc. assumes no responsibility whatsoever for any
statements made by me. I''m entirely on my own here.


"Samantha" wrote:

I have a template in which I need the last column totaled. I cannot use the
atuo sum feature because not all of the rows will always be filled. I know I
can use the Tools Calculate feature, but since this form is going out to many
people, I was hoping that there would be a way to do it automatically, so
there is no chance of people forgetting how to do it. I cannot figure out
how to create a macro to do it for me.

  #8   Report Post  
Posted to microsoft.public.word.tables
Tom Conrad Tom Conrad is offline
external usenet poster
 
Posts: 88
Default Automatically totaling a column in a table

Samantha,

The following reply is copied from a reply to a similar question

Question: How to input formulas into a sales invoice tamplet from Word?
Posted by: Rosy3392
Posted 7/11/2007

Tom C replied:

Take a look at the following article:
Article: How to get a formula field to total an entire table column, even if
some cells in the column contain text or are blank.

Article By Dave Rado
http://word.mvps.org/FAQs/TblsFldsFms/TotalColumn.htm

This article suggests two methods to achieve the effect you desire within
Word without embedding an Excel spreadsheet. Both methods use a mixture of
bookmarks and field codes.

The numbers to be summed are placed in a data table (Table01), and the
formulae are placed into a summation table.

The tables are separated by a blank paragraph. The article specifies a line
height for the paragraph. I would also recommend the font size should be set
to 1pt.

The total numbers of rows in table 01 can be varied with out disrupting the
formulae.

Tom C

--
Tom Conrad


"Samantha" wrote:

I have a template in which I need the last column totaled. I cannot use the
atuo sum feature because not all of the rows will always be filled. I know I
can use the Tools Calculate feature, but since this form is going out to many
people, I was hoping that there would be a way to do it automatically, so
there is no chance of people forgetting how to do it. I cannot figure out
how to create a macro to do it for me.

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Totaling merged data in new document Roy Carlson Mailmerge 13 June 30th 06 08:18 PM
Table Column Widths Automatically Resize The Merg Tables 1 April 11th 06 09:25 AM
Totaling columns Edward Frost New Users 1 April 2nd 06 11:39 PM
In a Table, How can I multiple column 1&3 to place in column 4 Marine Tables 1 December 3rd 05 07:45 PM
How to paste a column of text into a column in a Word Table Sam Page Layout 2 July 31st 05 08:03 PM


All times are GMT +1. The time now is 09:30 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"