Count items between specific hours on a matching date
 

I have a scanning project where I now need to report the number of scans per
hour each day.

I have all the data where the date is in column C and time in column d. In
row 1 starting at column H is 7:00am, 8:00am, etc. In column I are dates;
11/30/04, 12/01/04. What I am looking for is how many scans occured each day
within what hours. I have the hour formula
=SUMPRODUCT(($D$2:$D$3000=H$1)*($D$2:$D$3000<=I$1 )) which shows how many
were done between 7am and 8am for all days. I just want the ones done at that
time on the date in I2 (11/20/04).

Help!

Can't you just add in a term to check that the date column value matches I2?
, e.g.;

=SUMPRODUCT(($D$2:$D$3000=H$1)*($D$2:$D$3000<=I$1 )*($C$2:$C$3000=I$2))


"KS" wrote in message
...
I have a scanning project where I now need to report the number of scans
per
hour each day.

I have all the data where the date is in column C and time in column d. In
row 1 starting at column H is 7:00am, 8:00am, etc. In column I are dates;
11/30/04, 12/01/04. What I am looking for is how many scans occured each
day
within what hours. I have the hour formula
=SUMPRODUCT(($D$2:$D$3000=H$1)*($D$2:$D$3000<=I$1 )) which shows how many
were done between 7am and 8am for all days. I just want the ones done at
that
time on the date in I2 (11/20/04).

Help!