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 !

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.

Try this:

B4: =A4/$A$1
copy that formula down as far as you need.

Note: the dollar signs in the references lock-in that part of the reference.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"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 !

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