XL5: AutoSum Feature Does Not Work Properly on Large Ranges

ID: Q125638

5.00 WINDOWS kbtool

The information in this article applies to:

• Microsoft Excel for Windows, version 5.0

SUMMARY

In Microsoft Excel, when you use the AutoSum tool to calculate data in a range that contains a large number of cells, you may not receive the results you expect. For example, one or more cell references may not be included in the sum formula after. The following table lists the total number of sum formulas you can have for a given range.

   Number of cells      Total number of
   in range             sum formulas allowed
   -----------------------------------------

   Less than 100        Up to 15
   From 100 to 115      Up to 14
   From 115 to 200      Up to 13

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel version 5.0c for Windows.

REFERENCES

"Microsoft Excel Users Guide," "Using the AutoSum Button," pages 153-156

KBCategory: kbtool KBSubcategory:

Additional reference words: 5.00

Version           : 5.00
Platform          : WINDOWS

Last Reviewed: March 28, 1997