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