In my Template, I have a column in a table that will contain currency when
all the form features are filled in.

In the form, some of the cells have Form Text Boxes to instruct the user to
paste some data from an Excel Worksheet.

The last cell in the column is the total of the column and I typed a common
formula =SUM(Above) , which works is all the cells have numbers in
them.

I would like to type a formula similar to what I would type in Excel,
=SUM(M12:M20) . But, I don't know how to identify the cells in the Table.

Is there a formula to do what I want to do? remember that there is text in
some of the cells as a template, and they become numbers when the .doc
document is complete.

Darrell

Move to the cell where you want your formula, click TABLE in the menu and
select FORMULA. In the drop down list select the formula you wish to use, in
this case as SUM function, and then enter the cell addresses as you would in
Excel.

It treats the table column as if it were identified by an alpha character,
so column 3 row 2 would be entered into the formula as C3

=Sum(B1:B33) would sum all the cells in the second column of the table, rows
1 through 33 inclusive.
--
Kevin Backmann


"Dr. Darrell" wrote:

In my Template, I have a column in a table that will contain currency when
all the form features are filled in.

In the form, some of the cells have Form Text Boxes to instruct the user to
paste some data from an Excel Worksheet.

The last cell in the column is the total of the column and I typed a common
formula =SUM(Above) , which works is all the cells have numbers in
them.

I would like to type a formula similar to what I would type in Excel,
=SUM(M12:M20) . But, I don't know how to identify the cells in the Table.

Is there a formula to do what I want to do? remember that there is text in
some of the cells as a template, and they become numbers when the .doc
document is complete.

Darrell

See http://word.mvps.org/FAQs/AppErrors/...eIncorrect.htm and
http://gregmaxey.mvps.org/Table_Cell_Data.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Dr. Darrell" wrote in message
...
In my Template, I have a column in a table that will contain currency when
all the form features are filled in.

In the form, some of the cells have Form Text Boxes to instruct the user
to
paste some data from an Excel Worksheet.

The last cell in the column is the total of the column and I typed a
common
formula =SUM(Above) , which works is all the cells have numbers in
them.

I would like to type a formula similar to what I would type in Excel,
=SUM(M12:M20) . But, I don't know how to identify the cells in the
Table.

Is there a formula to do what I want to do? remember that there is text in
some of the cells as a template, and they become numbers when the .doc
document is complete.

Darrell