Imported tables within word

C

Charlie Arbon

Hi, I have a problem with a imported table in word, thetable consists of The
title in the top row then four rows of text the the bottom row for the
result.When i formulate the total there is no problem and the total is
displayed and is correct, when i try to average the four rows above the
formula is calculating the four rrows with the numbers in plus the top row
that contains the title making a total of five rowa and of course the wrong
answer each time. Any ideas any one out there. This is in WORD not exel it
works perfectly in exel, this is the formula i am using =average(above).Have
i enabled or disabled some thing that i shouldnt haveAt my colage it works
fine on MS XP I am using office 2000
Regards C R Arbon
 
S

Suzanne S. Barnhill

Obviously, you can't use (above) in this formula. You will need to reference
the cells specifically. See the examples in Word's Help topic "Field codes:
= (Formula) field."

For help with getting cell addresses (in larger tables than this), you can
use the TableCellHelper macro available from
http://www.mvps.org/word/FAQs/AppErrors/SumAboveIncorrect.htm

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