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