Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to get a count on an hourly basis
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to get a count on an hourly basis
=SUMPRODUCT(--(HOUR(A1:A20)=11)) will count orders received between 11:00 and 11:59 Does this help? "Arun2902" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to get a count on an hourly basis
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. "Toppers" wrote: =SUMPRODUCT(--(HOUR(A1:A20)=11)) will count orders received between 11:00 and 11:59 Does this help? "Arun2902" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to get a count on an hourly basis
=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) "Toppers" wrote in message ... =SUMPRODUCT(--(HOUR(A1:A20)=11)) will count orders received between 11:00 and 11:59 Does this help? "Arun2902" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals by count | Excel Discussion (Misc queries) | |||
Count consecutive dates only | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |