=sum(above) in Word 2003

[mjt44]

I'm trying to sum what I think is a pretty simple column of dollar figures in
a table. There are eleven rows in the table - row 1 is the headings row,
rows 2-10 have my items, and row 11 is where I want the total. There are
seven columns. The dollar figures come from a calculation of quantity
(column 1) X price (column 6). Every time I insert the {=sum(above)}
calculation in the last cell at the bottom right, it brings back an answer of
"!I22 Is Not In Table".

What am I doing wrong?

 

[Cindy M.]

Hi =?Utf-8?B?bWp0NDQ=?=,

I'm trying to sum what I think is a pretty simple column of dollar figures in
a table. There are eleven rows in the table - row 1 is the headings row,
rows 2-10 have my items, and row 11 is where I want the total. There are
seven columns. The dollar figures come from a calculation of quantity
(column 1) X price (column 6). Every time I insert the {=sum(above)}
calculation in the last cell at the bottom right, it brings back an answer of
"!I22 Is Not In Table".

Strange...

If you select the entire table, then press F9 to force all the fields to update,
does any other field show an error?

Did you quote the error message correctly, BTW? I22 would be column 9, row 22,
which I find exceedingly odd.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[mjt44]

Cindy:

Thanks for taking an interest in my dilemma. And, in fact, your questioning
of I22 got me to thinking. Then it dawned on me that when we first started
this form (we were converting it from an Excel form) we did a "paste special"
of an Excel table into the form. Thus Word was remembering the cell
locations from when they were in Excel.

So although painful, I deleted that table and started from scratch. Voila,
it works!!

Thanks again,
Mike

 

[Cindy M.]

Hi Mike,

Thanks for taking an interest in my dilemma. And, in fact, your questioning
of I22 got me to thinking. Then it dawned on me that when we first started
this form (we were converting it from an Excel form) we did a "paste special"
of an Excel table into the form. Thus Word was remembering the cell
locations from when they were in Excel.

So although painful, I deleted that table and started from scratch. Voila,
it works!!

Thank you very much for taking a moment to describe the resolution of the issue.
I had wondered if something like that was going on, although I find it
exceedingly odd that this carried over. Glad you got it straightened out!

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail