I have a spread sheet that I am taking over and it includes average mileage.

The only issue is that not all the data is the same. Some of the entries are for example 10,000 / YR while others are 500 / MON is there a way to calculate the average without having to reformat the entries that are different than the other. (the majority of the entries are /MON)