Try:

on Sheet2:

A2=Date
B2=Team
in C2:

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

HTH

" wrote:

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