It is possible, by using the this formula.
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.
I've created an example file for you: Sum IMPORTHTML table