I tried this but it It still is not giving me what I need. I'm tring to
count how many people are waiting whenever someone new arrives. I need to
compare each time in col A (Arrival) agaist each pair of times in cols b&c
and count the times that a falls between them. Thank-you Zb


"Max" wrote:

Assuming start times in col C, end times in col D
In B1: =SUMPRODUCT((A$1:A$100=C1)*(A$1:A$100<=D1))
Copy down to the extent of paired times in cols C and D. Adapt the range in
col A to suit beforehand.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Zb Kornecki" wrote:
Please help me write a SUMPRODUCT formula
I have 3 columns
A=arrival time
C=time 1
D=time 2
I would like column B to show a count of how many times Col A falls between
each C & D pair
Thank-you
Zb