Totaling Columns and Rows

Totaling All Numbers in a Column

To find the total of all numbers in a column:

  1. Select the cell where you would like your total to appear. Note that it does not matter where the cell is in the column - the total of the entire column will be placed in the selected cell.

  2. Go to the Data menu, and click Total All Nos. in Column. Or, if you are in Easy Mode, click the Total all Numbers in this Column button (in Advanced Mode, click the smaller icon shown below).

 

  1. All the numbers in the column will be totalled. Total =, followed by the total, should appear in the cell you selected. Note that this total is a label, and thus, cannot be used in calculations.

 

Totaling All Numbers in a Row

To find the total of all numbers in a row:

  1. Select the cell where you would like your total to appear. Note that it does not matter where the cell is in the row - the total of the entire row will be placed in the selected cell.

  2. Go to the Data menu, and click Total All Nos. in Row. Or, if you are in Easy Mode, click the Total all Numbers in this Row button (in Advanced Mode, click the smaller icon shown below).

 

  1. All the numbers in the row will be totalled. Total =, followed by the total, should appear in the cell you selected. Note that this total is a label, and thus, cannot be used in calculations.

Note: If ##### appears in the total cell, the column is not wide enough. Increase the column width, and your total will be visible.