View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default SUMIF Greater than or equal to

Another way using sumproduct()

=SUMPRODUCT(('Tab1'!A2:A200=A2)*('Tab1'!A2:A200<= B2),'Tab1'!B2:B200)

If this post helps click Yes
---------------
Jacob Skaria


"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