View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default SUMIF Greater than or equal to

I think the arrays need to be the same size. In one case you have from row 2
to row 200, and in others it's row 4 to 200.

HTH,
Barb Reinhardt

"envy" wrote:

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