group by er fint
SELECT id, SUM(kroner), in_ut, aar
FROM regnskap_inn_ut WHERE aar='2012' AND in_ut='1'
GROUP BY id, in_ut, aar