Excel: How do I sum the contents of a column?

Problem:

Microsoft Excel: How do I sum the contents of a column?

Solution:

If, for example, you want to sum the contents of column A1 to A15 and have the result in A16 Excel can perform the calculation for you.

  1. Click in cell A16.
  2. Type =Sum(A1:A15).
  3. Press Enter.

The result of the calculation will be displayed in cell A16. If any of the values in cells A1 to A15 are changed, the result in A16 will also change to reflect the changes in A1-A15.

Did this document solve or help you with your problem?

Yes   No  

Category: Software : Excel     Platform: All Windows
Document #: 411     Author: Elizabeth Golden    
Last Modified by: Cynthia Senicka on 03/05/2008