Microsoft KB Archive/70015

From BetaArchive Wiki

Using the Expression Field to Sum Table Columns

PSS ID Number: Q70015 Article last modified on 11-10-1993

1.00 1.10 1.10a 2.00 2.00a 2.00a-CD 2.00b 2.00c WINDOWS

The information in this article applies to:
- Microsoft Word for Windows versions 1.0, 1.1, 1.1a, 2.0, 2.0a, 2.0a-CD, 2.0b, 2.0c - Microsoft Windows operating system version 3.0 and 3.1

Summary: When you use an expression field to sum a table column in Word for Windows 1.0 and 2.0, the syntax that refers to the column will vary, depending on the placement of the field.

More Information: You can place the expression field in the column you are summing, in a different column, or outside the table. The syntax for the column reference will differ depending on the placement. The following examples illustrate the differences: 1. When the expression field is in the same column that is being summed, you must put the range of cells in the field: {=sum ([RxCx:RxCx])} 2. When the expression field is in a column other than the one being summed, you may refer only to the column number: {=sum ([Cx])} (you may also use method one) 3. When the expression field is outside the table, you must select the table and insert a bookmark: {=sum (T1[Cx])} or {=sum (T1[RxCx:RxCx])} “T1” is the bookmark name.

Reference(s): “Microsoft Word for Windows and OS/2 Technical Reference,” page 342. Microsoft Press, 1990.

Additional reference words: w4wfield add adding 1.0 1.1 1.1a 1.00 1.10 w4wtable 1.10a 2.0 2.00 2.00a 2.0a ============================================================================= Copyright Microsoft Corporation 1993.