Need to get a count on an hourly basis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

Need help with getting the count of the number of orders that were submitted
on an hourly basis. For example: Col A has the name of the vendor, Col B has
the Date and Col C has the Time when the order was placed. I need help in
counting the number of orders that were received in a particular hour.

Appreciate any help with this.

Arun
 
=SUMPRODUCT(--(HOUR(A1:A20)=11))

will count orders received between 11:00 and 11:59

Does this help?
 
Wow. That worked like a charm. If you could give me an option within the
formula to include a date ... I would be eternally grateful to you. Thank you
for your help Toppers.
 
=SUMPRODUCT(--(HOUR(A1:A20)=11),--(B1:B20=--"2006-6-05"))

for 5th June

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You must log in or register to reply here.

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

Similar Threads

Count columns that meet criterias 3
Add Time Q 4
Comparing the values in two cells, then counting how many differ 2
Count Distinct Values based on criteria 4
Multiple Criteria & Count if Equals 0 4
Counting number of rows based on mutiple criteria 2
Complicated Formula - I think 3
Count with date range 2

Back
Top