Easier than I thought;

select sum(A * B)/ SUM(B)

Works a treat.