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 !

In Cell B4, enter the formula

=A4/$A$1

and copy all the way down.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=534703