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

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:

share|improve this question
what URL you're thinking off? – Jacob Jan Tuinstra Sep 19 '13 at 10:35
Are you getting a specific error back? What's not actually working for you? The full function you're using could be helpful; you might not be importing the right data. – Andrew Lott Sep 19 '13 at 11:26
Hi Guys, Thanks for getting back. I have attached the URL i am working with as well as the formula for google spreadsheet. – lancegoh Sep 22 '13 at 5:48
up vote 0 down vote accepted

It is possible, by using the this formula.




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

  1. text to number conversion
  2. 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.


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

share|improve this answer
Thanks for that! – lancegoh Sep 22 '13 at 12:20

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.