Hi all,
Thanks for any help you can give.
I have a spreadsheet of data, that has a number of columns which represent various stages of a process from entry date to completion date and stages in between. I am looking to calculate an average between various stages in the process, by months so I can track our progress of completing jobs to the various stages. The months element would be the date which the entry was started. Example - in April 2015 we received 500 jobs, what is the average number of days to finish those 500 jobs. Average days from start date to finish date across 500 jobs?
I am thinking i need to use "averageifs"??
I think I have articulated my problem, and once again thanks for any help you can give.
Thanks for any help you can give.
I have a spreadsheet of data, that has a number of columns which represent various stages of a process from entry date to completion date and stages in between. I am looking to calculate an average between various stages in the process, by months so I can track our progress of completing jobs to the various stages. The months element would be the date which the entry was started. Example - in April 2015 we received 500 jobs, what is the average number of days to finish those 500 jobs. Average days from start date to finish date across 500 jobs?
I am thinking i need to use "averageifs"??
I think I have articulated my problem, and once again thanks for any help you can give.
