I can not figure out how to apply a continual formula to a column of figures.
Ex. There is a specific number is cell A1.

I would like to enter a formula of "=sum(A4/A1)" into cell B4
Then.........................................."=su m(A5/A1)" into cell B5

How do I get an entire portion of column A to all be divided by cell A1 and
put
the answers in the corresponding B cells ?

Thank you in advance for your time ! Much appreciated !