You could do a simple equation. Assuming your original column starts at A1 and you average column starts at B2 then something like SUM(A$1:A1)/COUNT(A$1:A1). That's the simplest way. Or just use the AVERAGE function. AVERAGE(A$1:A1).