Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi -
I am trying to determine the number of customers I get in a specific time range. My spreadsheet is as follows: Tab 1 gives customers and times: A B Time # Customers 6:05 1 7:30 50 8:15 20 etc. Tab 2 I calculate based on time ranges A B C Start End # of customers 6:01 6:30 need formula 6:31 7:00 7:01 7:30 etc. Does anyone have a good formula? I have tried a few and the latest one isn't working right: =SUMIFS(Tab1!b2:b200,Tab1!a4:a200,"="&A2,Tab1!a4: a200,"<="&B2) Any suggestions.... Thanks! -- en |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Greater/Less Than or Equal To | Excel Discussion (Misc queries) | |||
sumif date is greater than or equal chosen date | Excel Discussion (Misc queries) | |||
IF with Equal to or Greater than | Excel Discussion (Misc queries) | |||
Greater than or equal to (Plus or minus) | Excel Discussion (Misc queries) | |||
First occurance greater than or equal to a specified value | Excel Worksheet Functions |