Summing several cells in the column...


I am trying to get a formula that will allow me to take several different cells in the same column, and total it up onto a different spreadsheet. 

I will say there are about 6 cells to add and i want them totaled into one cell on a different spreadsheet.

Thank you 

Jeff Smith 




The task is easier if you reverse your logic. It isn't several cells you wish to sum up in another spreadsheet. Instead, it is the other spreadsheet which is to show the sum of several cells from your list. Therefore you need a formula in the other spreadsheet, to be precise, in the cell where you wish to see the total. For example,


Here, "Sheet1" is the name of the tab with the list. Observe that it is followed by an exclamation point. If there are blank spaces in the name, surround the name with apostrophes, like, =SUM('My Sheet'!$A$3:$A$13)

If the cells you wish to sum up are not in a contiguous range you can expand the system like this

=SUM('My Sheet'!$A$3:$A$6,'My Sheet'!$A$8:$A$13)
or like this
=SUM('My Sheet'!$A$3,'My Sheet'!$A$8:$A$10,'My Sheet!$A$13)
=SUM('My Sheet'!$A$3:$A$6) +'My Sheet'!$A$13

Answer the Question

You must create an account to use the forum. Create an Account or Login