If you want a SP you should do soemthing like the next code:
CREATE PROCEDURE [dbo].[GetTotalCount]
AS
BEGIN
Select Table1.Price + Table2.Price + Table3.Price + Table3.Price+Table4.Price+Table5.Price+Table6.Price as TotalCount FROM Table1,Table2, Table3, Table4,Table5,Table6
END