Count items between specific hours on a matching date

K

KS

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!
 
D

Dave R.

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top