I've figured out how to import HTML table into Google spreadsheets, but is there a way to sum a row?I want to get a sum of Total Revenue from Nasdaq.This allowed me to pull the quarterly data from Nasdaq:=arrayformula(index(importhtml(http://www.nasdaq.com/symbol/ko/financials?query=income-statement&data=quarterly, table,0)))I thought I could sum the entire row by adding this to the end:sum(c2+d2+e2+f2)))It doesn't work and I get an error:=arrayformula(index(importhtml(http://www.nasdaq.com/symbol/ko/financials?query=income-statement&data=quarterly, table,0),sum(c2+d2+e2+f2)))))Am I supposed to just find the 4 data and sum them instead of summing them after I pull the data?
Get the sum of every row in a table imported with Importhtml
google spreadsheets