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

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?

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

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

Can you post example of layout of data?

"MarilynD." wrote:

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?

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

How do I post the layout in here, Topper?

"Toppers" wrote:

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

Can you post example of layout of data?

"MarilynD." wrote:

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?

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

If it's easier send me the file

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
"MarilynD." wrote:

How do I post the layout in here, Topper?

"Toppers" wrote:

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

Can you post example of layout of data?

"MarilynD." wrote:

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?