Hi
In Column J I have the job status (ie Must only include "Complete")
In Column H I have the workstream (Must only be "France")
In Column G I have the start date
In Column Q I have the completed date
What I need is IF it is COmplete AND France
Then for the Average time to complete all those jobs to be displayed
Thanks in advance
In Column J I have the job status (ie Must only include "Complete")
In Column H I have the workstream (Must only be "France")
In Column G I have the start date
In Column Q I have the completed date
What I need is IF it is COmplete AND France
Then for the Average time to complete all those jobs to be displayed
Thanks in advance