200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
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,
=SUM(Sheet1!$A$3:$A13)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)=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