Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Has anyone been able to return the SUM() result of a column in one Google Spreadsheet to a different spreadsheet?

I am trying the ImportRange(key, criteria) but I am not having any success. I am just bringing in the entire column and not the sum result.

share|improve this question
Have you tried to sum that? – Jacob Jan Tuinstra May 6 '13 at 20:09

If you want to leave the data on the IMPORT sheet untouched, then you need to do this:


This is a good post, here on Web Applications, about the IMPORTRANGE function: IMPORTRANGE

share|improve this answer

ImportRange(...) is indeed the function you need to use. Here are the steps you need to follow:

  1. At Spreadsheet 1 sum up the values you want to a specific cell (e.g. A4)
  2. On the address bar of Spreadsheet 1 check for the key value (it's the long number that starts after key= and ends before #gid) - e.g. key=ABC -
  3. At spreadsheet 2 go to the cell to which you need to present the sum and write =ImportRange("key","SheetName!CellName"), e.g. based on our example =ImportRange("ABC","Sheet1!A4")

You can also refer to this post ImportRange

share|improve this answer
BTW: I had to use =ImportRange("key";"SheetName!CellName") to make it work. (using a ";" instead of a ",") and it doesn't work yet with new google sheets. – StampedeXV Mar 3 '14 at 16:36

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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