View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
 
Posts: 703
Default SUMIF Greater than or equal to

Hi

Look at this:

=SUMIF(Tab1!A2:A20,"="&A2,Tab1!B2:B20)-SUMIF(Tab1!A2:A20,""&B2,Tab1!
B2:B20)

Regards,
Per

On 29 Okt., 00:47, 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