I have a list of numbers (bus miles) I want to find the monthly a.

[Guest]

In excel I have a row of mileage numbers for each bus. There are 4 buses. I
want to average the mileage for each bus individually as well as by the group
for each month.

Can anyone help?

 

[Guest]

Is there one (or more?) row per bus and is each column a month's mileage?

Can you post example of layout of data?

 

[Guest]

How do I post the layout in here, Topper?

Is there one (or more?) row per bus and is each column a month's mileage?

Can you post example of layout of data?

 

[Guest]

If it's easier send me the file ==>[email protected]

A sample "layout" would be:

Col A Col B Col C Col D
Bus Id Jan Feb Mar
1234 5600 7890 6789 <==== Monthly mileage figures
4567 4567 1234 5643

HTH