Formula to total column with blanks/text

[Rita King]

Using Word2002, I have been trying to get the formula from:

http://word.mvps.org/FAQs/TblsFldsFms/TotalColumn.htm

to work in my table. The only change I made to the formula shown was to
change the cell reference to B:B. Like so:
SUM(Table1 B:B) \# "#,##0.00;- #,##0.00;''"

This of course appears within field braces {}

Sadly, nothing happens. No error, no number, nothing.

Can anyone assist? Maybe it doesn't work with Word2002?

 

[Greg Maxey]

Rita,

The obvious element missing is the "=" sign

{ =Sum(Table1 B:B) \# "#,##0.00;- #,##0.00;''" }

 

[Rita King]

Greg, you beauty! That's it. Oh, the time I have wasted.
Thanks a lot.