Averaging a time field from a SUMPRODUCT result

N

Nick Gill

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<=($I346+$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 are:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
formula help 2
sumproduct conditional statement 1
Would I use LOOKUP for this? 2
SUMPRODUCT problems...argh... 10
sumproduct 2
change cell color depending on two cell values 1
averaging data in multiple columns 6

Top