Sure it can. You will need to copy the formula to the other cells in column
C. Please send me an email at and I will send you an
attachment with the formula populating column C.

Mary

"TM" wrote:

That only works for one cell in that particular row.

I want to be able to enter the miles and gallons in any row and have it
automatically calculate mpg for that row,

Here is some sample data:
Miles Gall MPG
200 10 20


That formula works great but there seems to be no way to have it use that
formula all the way down the sheet for any value entered into miles-column,
gallons-column and have it calculate mpg

Can this be done ?
--
Tony



"Lern2Ern" wrote in message
...
Tony, in Column C, type the formula =sum(a1/b1). This should give you the
result you are looking for.

Hope this helps

"TM" wrote:

Is there any way to setup a sheet or create a formula so that it will
divide
the data in column A by Column B anytime the data is entered and put it
into
columnC ?

What I am trying to do is create a spreadsheet for calculating fuel MPG.
So
I have columns as miles, gallons and the calculation as MPG.

What I want to do is anytime a value is entered into miles and gallons,
to
calculate mpg and put it into that respective cell.

Is there any way I can do this ?
Thanks
--
Tony