The error should sort itself once the Buy Amount and Quantity are entered. Because I have used "" in the rate calculation for missing data, the calculation for **stockCost **

= SUM( Table1[BQntyTP] * Table1[BRateTP] )

errors. Returning 0 for the rate, rather than "", would sort it but, looking at the formula for **stockCost **now, the calculation looks unnecessarily complicated

**= SUM( Table1[BAmtTP] )**

would do just as well. This is also a standard calculation that can be performed by any Table by switching on the Total row.

As for returning stock prices, that is outside my knowledge. In Office 365 there are stock prices 'powered by Bing'. From Excel 2010 it has been possible to use Power Query but I wouldn't know the data source; and the Excel version is still too recent for you. Google has been web-centric for much longer than Microsoft Office.

Perhaps you should post a new question for help with the data source. Help with Google sheets may require moving to a different forum.