You get better help if you add an ecel file.

But just a shot.

a1 =sum($B1:$B1000)/sum($C1:$C1000)