Microsoft Excel: Quick Sum a Data Range

You can quickly sum a block of data (both Rows and Columns) in Excel with just one click.

    • Start by selecting the data including the cells that will contain the SUM Formulas. (in our example Column E and Row 11)

excel-tip-quick-sum-may-1

    • On the Home Tab in the Editing Section, click the SUM button.
    • Excel will create a SUM function for each Row and Column.

excel-tip-quick-sum-may-3

 

 

 

 

 

 

 

 

 

For more excel techniques see our Excel Training Class