XL5: AutoSum Feature Does Not Work Properly on Large Ranges |
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
Additional query words:
Keywords :
Version : WINDOWS:5.0
Platform : WINDOWS
Issue type :
Technology :
Last Reviewed: January 6, 2000 |
