Need help determining formula

This should be simple for the pros but I've spent hours researching and can
not come up with a solution. Lets say you have 3 columns A, B & C. 10 rows
of numbers in Column A and 10 rows of numbers in column B, what is the
formula for A/B to appear in column C for all ten rows. In actuality, I have
over 1000 rows of data and I dont want to enter =SUM(A1/B1) in each row of
column C. What is the formula that will automatically compute A/B for many
rows to appear in C. Your help will be greatly appreciated.
galevin@hotmail.com

In C1 enter
=Sum(A1/B1)

then reselect the cell.
in the lower right corner of the highlight, you should see a small square.
Double click on it and it should fill down.
--
Regards,
Tom Ogilvy


"Nobody@nobodieshome.com" <guess@who.com> wrote in message
news:zf-dndvt1furoJLeRVn-hQ@comcast.com...
> This should be simple for the pros but I've spent hours researching and
can
> not come up with a solution. Lets say you have 3 columns A, B & C. 10 rows
> of numbers in Column A and 10 rows of numbers in column B, what is the
> formula for A/B to appear in column C for all ten rows. In actuality, I
have
> over 1000 rows of data and I dont want to enter =SUM(A1/B1) in each row
of
> column C. What is the formula that will automatically compute A/B for many
> rows to appear in C. Your help will be greatly appreciated.
> galevin@hotmail.com
>
>

Worked perfectly. Thanks Tom for the help!!!!!!!!!!!!


"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:Op1j5glqFHA.3404@TK2MSFTNGP11.phx.gbl...
> In C1 enter
> =Sum(A1/B1)
>
> then reselect the cell.
> in the lower right corner of the highlight, you should see a small square.
> Double click on it and it should fill down.
> --
> Regards,
> Tom Ogilvy
>
>
> "Nobody@nobodieshome.com" <guess@who.com> wrote in message
> news:zf-dndvt1furoJLeRVn-hQ@comcast.com...
>> This should be simple for the pros but I've spent hours researching and
> can
>> not come up with a solution. Lets say you have 3 columns A, B & C. 10
>> rows
>> of numbers in Column A and 10 rows of numbers in column B, what is the
>> formula for A/B to appear in column C for all ten rows. In actuality, I
> have
>> over 1000 rows of data and I dont want to enter =SUM(A1/B1) in each row
> of
>> column C. What is the formula that will automatically compute A/B for
>> many
>> rows to appear in C. Your help will be greatly appreciated.
>> galevin@hotmail.com
>>
>>
>
>