Google-sheets – How to SUM() a column from one Google Spreadsheets in another spreadsheet

google sheetsimportrange

Has anyone been able to return the SUM() result of a column in one Google Spreadsheets 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.

Best Answer

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

=SUM(IMPORTRANGE("key","range"))

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

Related Solutions

Sum Column Only if Another Column is Empty in Google Sheets

Replace ISEMPTY with ISBLANK

Your formula should be as follows:-

=SUM(FILTER(A:A, ISBLANK(B:B)))

Now you will get the result as 40

Google Sheets – Using ImportHTML and SUM Functions

It is possible, by using the this formula.

Formula

=SUM(ARRAYFORMULA(IFERROR(VALUE(RIGHT(index(importhtml("http://sgx.i3investor.com/servlets/stk/annent/t82u.jsp","table",7),,4),6)))))

Explained

There are two things that need to be taken into account:

text to number conversion
error capturing

The first is done by the VALUE function, that returns a number. The clue as to the second point starts here. The header of the table, can't be converted into a number !! Here the IFERROR function will return nothing if an error arises. Now the ARRAYFORMULA and the SUM can finish it off.

Example

I've created an example file for you: Sum IMPORTHTML table