| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
criteria + between dates
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
criteria + between dates
Super ! Thank you.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif between 2 dates and specify criteria | Excel Discussion (Misc queries) | |||
| Criteria Lookup based on Dates | Excel Discussion (Misc queries) | |||
| SUMIF function - criteria of between two dates. How? | Excel Worksheet Functions | |||
| can I use a range of dates as a criteria when using sumif? | Excel Worksheet Functions | |||
| how to sum using dates as a criteria | Excel Worksheet Functions | |||
Hybrid Mode
