Prev: referencing multiple cells when data is organised differently
Next: Please help very urgent ageing by if condiction
From: Nick Gill on 29 Mar 2010 07:55
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

 | 
Pages: 1
Prev: referencing multiple cells when data is organised differently
Next: Please help very urgent ageing by if condiction