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
is not working right:
=SUMIFS(Tab1!b2:b200,Tab1!a4:a200,">="&A2,Tab1!a4:a200,"<="&B2)
Any suggestions....
Thanks!
--
en