I have two different Google Sheets. They have 2 different names and are both listed in my Google Drive. They are identical except they contain individually keyed data. Cell and Colum names are identical.

To recap: These are NOT separate sheets on the SAME Google Sheet workbook, they are separate workbooks.

Is it possible to SUM a Cell in location A1: from Workbook named "This is workbook 1" to another separate URL address "This is workbook 2" ?

I know how to sum across tabs/sheets inside same workbook and that is not my question.

1 Answer 1


=IMPORTRANGE("sheet URL or key", "This is workbook 1!A1")

Replace "sheet URL or key" with your source sheet URL and "This is workbook1!A1" with the correct tab name and cell but in both cases keep them in double quotes.

IMPORTRANGE expects text not actual ranges/URLs.


  • To recap and to be clear, there is a long URL address to each of the workbooks and that goes inside the first parenthesis. Then the name of the workbook that is being imported goes inside the second set and where does the sheet name and cell go ? The reference to A1 could be any A1 cell in a multiple sheet/tab workbook.
    – rosa
    Sep 17, 2020 at 17:37
  • @rosa sorry, my bad formatting... have amended the answer accordingly. Sep 17, 2020 at 17:43
  • Ok. That worked, had to use format "Sheet1:A1:A1") and permissions across the two workbooks took forever to process (odd, since both are created by me and for me). Had to also shorten all extra URL characters (ie. #edit &gid= etc) from the URL address. Thank you
    – rosa
    Sep 17, 2020 at 17:53
  • @rosa Thanks... could you please mark the answer as accepted (and upvote) so others can find it if required in the future. It really does help the community to do this. Sep 17, 2020 at 17:57
  • 1
    @rosa where the up and down grey triangles are to the left of the answer and the tick check mark is. Hover over them with your mouse and it tells you the function of the symbol. see webapps.stackexchange.com/help/someone-answers Sep 17, 2020 at 19:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.