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