Hey guys, got a tough one that I need help with:
<tbody>
</tbody>
I am trying to find the average between the lead time on site (column C) and the non lead time on site (Column D) as it pertains to a date range. For the date range of 3/11-3/18 I need the average time it took the techs to complete the install. In some cases there was not a second technician so it would be just the average time of the lead tech on that date
- The answer/average for the date range of 3/11-3/18 I am looking for is 3.2
My formula (below) is spitting out a different number and I cant get it right. Any suggestions are helpful!
=AVERAGEIFS($C$2:$C$5,$A$2:$5,">="&”3/11/2016”,$A$2:$A$5,"<="&”3/18/2016”)+AVERAGEIFS($D$2:$D$5,$A$2:$A$5,">="&”3/11/2016”,$A$2:$A$5,"<="&”3/18/2016”)/AVG(IF(AND(ISNUMBER(C3),ISNUMBER(D3)),AVERAGE(C3:D3/2),AVERAGE(C3:D3)))
<tbody> </tbody> |
<tbody>
</tbody>
I am trying to find the average between the lead time on site (column C) and the non lead time on site (Column D) as it pertains to a date range. For the date range of 3/11-3/18 I need the average time it took the techs to complete the install. In some cases there was not a second technician so it would be just the average time of the lead tech on that date
- The answer/average for the date range of 3/11-3/18 I am looking for is 3.2
My formula (below) is spitting out a different number and I cant get it right. Any suggestions are helpful!
=AVERAGEIFS($C$2:$C$5,$A$2:$5,">="&”3/11/2016”,$A$2:$A$5,"<="&”3/18/2016”)+AVERAGEIFS($D$2:$D$5,$A$2:$A$5,">="&”3/11/2016”,$A$2:$A$5,"<="&”3/18/2016”)/AVG(IF(AND(ISNUMBER(C3),ISNUMBER(D3)),AVERAGE(C3:D3/2),AVERAGE(C3:D3)))