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