Google Sheets - Dynamic Sums

[BroProStudios]

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

 

 

[SparkySamZa]

just do =b2*b4

 

[BroProStudios]

6 minutes ago, SparkySamZa said:

just do =b2*b4

 

i still get the same error :C. The problem i think is that the b2 is a function not a number even though it shows the number. In the error message it says that it expects a number not text.

 

Thanks for the reply.

[BroProStudios]

I would also like to add. That i cant take the function away as i would like the live data. I don't know if it is possible to display the result of function in another cell and use that.