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

M

MarilynD.

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?
 
T

Toppers

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

Can you post example of layout of data?
 
M

MarilynD.

How do I post the layout in here, Topper?

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

Can you post example of layout of data?
Click to expand...
 
T

Toppers

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
 
Top