AppleWorks 6: Using Auto-Sum on Mulitple Columns

I am working on an AppleWorks 6 spreadsheet. When I try to use the Auto Sum function from the Calculate menu (or the associated button in the Button Bar) on multiple columns or rows of data, not all columns or rows are summed. I get similar incomplete results when I use the Auto Average function. How can I get all the sums or averages to appear?

There is a simple workaround for this situation. If you look at the contents of each cell that should show a sum or average, you will see that the correct formula is present even if the result does not appear in the cell. To make the result appear, simply select all the "empty" cells, choose Copy, then Paste. All the correct values should now appear.
Published Date: Feb 18, 2012