View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Paul Lautman
 
Posts: n/a
Default 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.