I'm doing this on a later version of Word, but I think Word 97 should behave the same--if not, someone will correct me
Is B37 empty? When I try your scenario, Sum Above stops when it finds a blank cell--starting from the cell directly above the formula and counting up. A solution would be to replace empty cells with a "0" (zero-no quotation marks). Then select the formula and press F9 to update the Field (you can also right-click on the formula result and choose Update)
Another possibility: Did you enter any of the values after you entered the formala? If so, you should select the formula and then press the F9 key on your keyboard to update the formula--Word won't do it automatically in most cases
You might also try changing your formula to say =sum(b1:b40), but you would only want to do this if you won't be adding rows. I used B1 only as an example starting point, you should put the first cell that contains a number you want to add
t
----- Rather Knott wrote: ----
I am using M.S. Word 97 to create a document with 8 columns and 40 rows. In col 'B' is 40 entries eg
$23.20. My problem is when I execute 'sum=(above) only rows 38, 39 &40 are added. I have checked fo
invalid entries, characters etc., and can find none
This problem is not encountered when I total Cols. D, F & H
All/any assistance is appreciated.
