conditional count of cells between dates
 

I have a colum within a table that indicates one of three things:
1. the date an interview took place as dd/mm/yy/hh:mm
2.string- 'declined on phone'
3. string-'declined at interview'.

using a SUMPRODUCT function kindly figured out by Bob, I have a way to
calculate the number of successful interviews between two dates:
=SUMPRODUCT(--('researcher reports'!$G$2:$G$360=D2),--('researcher
reports'!$G$2:$G$360<E2))
where D2 and E2 provide the first and last days of the wekk in question.
I now would like to know the totals for 2. and 3. above, using the same
criteria of date intervals.
bound to be a simple solution, that I can't quite fathom!
many thanks for suggestions, Theo

conditional count of cells between dates
 

So where are the strings declined on phone and declinded at interview
located. Assume column H and the string is in F2

=SUMPRODUCT(--('researcher reports'!$G$2:$G$360=D2),--('researcher
reports'!$G$2:$G$360<E2),--('researcher reports'!$H$2:$H$360=F2))

--
Regards,
Tom Ogilvy


"TBA" wrote in message
...
I have a colum within a table that indicates one of three things:
1. the date an interview took place as dd/mm/yy/hh:mm
2.string- 'declined on phone'
3. string-'declined at interview'.

using a SUMPRODUCT function kindly figured out by Bob, I have a way to
calculate the number of successful interviews between two dates:
=SUMPRODUCT(--('researcher reports'!$G$2:$G$360=D2),--('researcher
reports'!$G$2:$G$360<E2))
where D2 and E2 provide the first and last days of the wekk in question.
I now would like to know the totals for 2. and 3. above, using the same
criteria of date intervals.
bound to be a simple solution, that I can't quite fathom!
many thanks for suggestions, Theo