criteria + between dates

R

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
 
T

Toppers

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Schedule Rotation 3
Arriving at totals 2
testing while suming 3
What Multiple functions do I need? 2
If Function 1
Paragraph numbering in Word 1
VBA Logic Problem 2
Tricky one 1

Top