Applying a formula to an entire column
Audrey wrote:
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 !
Try entering =A4/A$1 in B4 (the SUM() function is redundant) and then
copying down the formula.
|