PMRetired2012
Board Regular
- Joined
- Aug 6, 2019
- Messages
- 123
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
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