procterjames
New Member
- Joined
- Jul 24, 2006
- Messages
- 9
Right so ive got a spreadsheet that has the following columns
Average Days Date Recieved Date Complete Number Of Jobs
Basically i start a fresh sheet each month and what im trying to do is get the sheet to detect what has been done in the week I.E For each week i want it to average out the days for that week only .. and also add up the total amount of jobs (once again for that week only)
At the moment i do have a MONTHLY one that is working fine .. but what im trying to do here is sort it out so it does it automatically (I.E.) at the moment im having to average the weekly figures out by myself .. and im wondering if there is a way i can get excell to do this automatically for me??
I dont know if that makes alot of sense but if you have any ideas its greatly appreciated !
Cheers
Average Days Date Recieved Date Complete Number Of Jobs
Basically i start a fresh sheet each month and what im trying to do is get the sheet to detect what has been done in the week I.E For each week i want it to average out the days for that week only .. and also add up the total amount of jobs (once again for that week only)
At the moment i do have a MONTHLY one that is working fine .. but what im trying to do here is sort it out so it does it automatically (I.E.) at the moment im having to average the weekly figures out by myself .. and im wondering if there is a way i can get excell to do this automatically for me??
I dont know if that makes alot of sense but if you have any ideas its greatly appreciated !
Cheers