SELECT
Customerid,
sum(case when vouchartype = 'C' THEN -amount ELSE amount END) As AMount
FROM YOurTable
GROUP BY Customerid