Hi,
I am creating a document to to manage my silver stack. I am using google sheets and have got a cell that pulls to spot price of silver and displays it as a number. The problem i am having is that when i go to =sum i get a #value! error. The function i uses is as follows
=INDEX(ImportHTML("https://www.bullionbypost.co.uk","table",1),3,2)
and the sum is
=sum(b2*b4)
b2 is were i put the data from the import and b4 is the amount of oz of silver.
Just wondering if anyone can help me thanks