SUM + GROUP BY is the way to go, so long as you have Value pre-calculated:

SELECT Service_Name, SUM(Price) AS Price, SUM(Qty) AS Qty,
       SUM(Value) AS Value, Ident
FROM NewOne GROUP BY Service_Name, Ident