Example: On one spreadsheet, I have columns and rows of data (A1 through G10). On a separate spreadsheet, I am trying to get the sum of each of the columns from the first into a column running down on the second spreadsheet.

On the second sheet enter in the
You can repeat the same process for the other cells. For example:



In order to get a total of the entire column, no matter how many rows of data there are, use the following formula in the cell you want the total on the second sheet.
Repeat this formula in each cell you want the total for a column and change the 


On Sheet2 use this formula and copy down to occupy seven rows.
This formula does not require any moving or editing of cells or creating the sum manually for each result cell. 

