sorry, you said per Million Miles. Here is a correction.

=C9/(C8/1000000)

or

=(C9/C8)*1000000

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
use a formula in row 10 column 3

=C9/C8

then drag fill to the right


--
Regards,
Tom Ogilvy


"Craigm" wrote in
message ...

I need to calculate the number of Accidents Per Million miles traveled.

I have a spreadsheet "Mileage" that has total miles per month in
columns:
1,047,178 1,014,900 1,050,481 1,049,958 948,471

I have a spreadsheet "Accidents" that has the total accidents per month
in colums:
8 11 6 16 9

I don't have any idea how to write this macro. I have two years worth
of data and each month new data is entered as totals.

The miles driven data starts in Row 8 column 3 and number of accidents
data starts in row 9 column 3.

Perhaps its the statistics calculations I don't grasp.

Any help would be greatly appreciated!

Thanks in Advance

Craig


--
Craigm
------------------------------------------------------------------------
Craigm's Profile:
http://www.excelforum.com/member.php...o&userid=24381
View this thread:
http://www.excelforum.com/showthread...hreadid=517346