I am using the following formula to obtain the number of calls for a period
of time:
=IF($M346="Outbound
Working",SUMPRODUCT((Call!$C:$C=$H346)*(Call!$G:$G ="Outbound")*(Call!$D:$D=$I346)*(Call!$D:$D<=($I3 46+$F346))),"")
This gives me back an answer (2), from this answer I now need to calculate
the average the call duration from a call duration field not in the original
Sumproduct.
the cells/columns used in the formula a
Call!$C:$C=User+Day
$H346=User+Day
Call!$G:$G=Call Direction
Call!$D:$D=Call Start Time
$I346=StartTime of Period
$F346=EndTime of Period
and the column I wish to get the Average Call Duration from is Call!$B:$B