View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] rumkus@hotmail.com is offline
external usenet poster
 
Posts: 22
Default criteria + between dates

sheet1 ( 4 columns. First 2 begin / end dates)

1/1 3/3 teamA 121
4/3 6/6 teamA 322
7/6 8/8 teamA 455
1/1 3/3 teamB 12
4/3 6/6 teamB 44
7/6 8/8 teamB 45

sheet2 ( data entry)

5/4 teamA ?

? =322 How can I get it with a formula

Thanks