Imported webpage data wont calculate formula's just show '0'

[brettalloy]

Hello,

Have tried a number of ways and searched for an answer to this and it's probably an easy fix.

I have a web link to a page and that is working great and I have seperated the columns I want ( d and e runs scored)
I wish to do sums regarding to run values in D and E but wherever I place the formula it won't add up.

I tried formatting these columns to general, then numbers but still no joy.

Thanks
B

 

[brettalloy]

I cant seem to find an option to attach the table, is it because I'm new?

 

[brettalloy]

Last try here really need some assistance with this, it will really help me out.

I have tried many different ways to fix this but still frustrated.

Thanks