criteria + between dates

[rumkus]

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

 

[Toppers]

Try:

on Sheet2:

A2=Date
B2=Team
in C2:

=SUMPRODUCT(--(A2>=Sheet1!A2:A10),--(A2<=Sheet1!B2:B10),--(B2=Sheet1!C2:C10),(Sheet1!D210))

HTH

 

[rumkus]

Super ! Thank you.