Applying a formula to an entire column

A

Audrey

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.........................................."=sum(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 !
 
P

Paul Lautman

Audrey said:
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.........................................."=sum(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 !
Click to expand...

Try entering =A4/A$1 in B4 (the SUM() function is redundant) and then
copying down the formula.
 
R

Ron Coderre

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
 
B

BenjieLop

Audrey said:
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.........................................."=sum(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 !
Click to expand...

In Cell B4, enter the formula

=A4/$A$1

and copy all the way down.

Regards.
 
Top