averaging months

[PMRetired2012]

I have a situation where i have 12 months in a row acroos my worksheet.( Jan-Dec), and i have 6 catgories with total number of students that attend across the top. each month has 4 dates. so what you have is each month they meet weekly and i have a attendance number.
I another place on the worksheet is where i have all the months listed and off the the side i once again put the 6 class catogerys. what i want to do is have a formula that will give me a adverage attendance based on the 4 weeks within the month and also i we havent came to that month to adverage yet that we have a 0 put in that cell.

so what im asking for is this: i want to be able to have a adverage formula or maybe be called a roling adverage for 4 weekly numbers as i enter the attendance. and be placed under each month in the proper catagory.


Thanks

 

[RasGhul]

Can you post some sample data?

 

[PMRetired2012]

Not sure how to do that

<colgroup><col><col span="37"></colgroup><tbody>
</tbody>

 

[RasGhul]

Just highlight the data on your sheet then CTRL+C to copy then CTRL+V to paste in a reply.

Only sample data is needed or paste direct if not sensitive info for you.