I am looking to use the importHTML function for loading a page and I would like to sum a particular column in Google Spreadsheets.But I am not having much success.This is the URL:=RIGHT(index(importhtml(http://sgx.i3investor.com/servlets/stk/annent/t82u.jsp,table,7),,4),6)
ImportHTML and SUM the column
google spreadsheets
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)))))ExplainedThere are two things that need to be taken into account:text to number conversionerror capturingThe 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.ExampleI've created an example file for you: Sum IMPORTHTML table