| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date ranges in a sum formula
I need to add a series of deposits received between two dates (6/1706 to
6/23/06) and can't figure out how to make it work. Help!! Marcus |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date ranges in a sum formula
E1, E2 are your two dates, A is list of dates and B your deposits
=SUMPRODUCT(--(A1:A20=E1),--(A1:A20<=E2),B1:B20) HTH "Marcus Caterino" wrote: I need to add a series of deposits received between two dates (6/1706 to 6/23/06) and can't figure out how to make it work. Help!! Marcus |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date ranges in a sum formula
Hi!
Try one of these: A1:A21 = dates B1:B21 = deposits D1 = 6/17/2006 E1 = 6/23/2006 =SUMIF(A1:A21,"="&D1,B1:B21)-SUMIF(A1:A21,""&E1,B1:B21) =SUMPRODUCT(--(A1:A21=D1),--(A1:A21<=E1),B1:B21) Biff "Marcus Caterino" <Marcus wrote in message ... I need to add a series of deposits received between two dates (6/1706 to 6/23/06) and can't figure out how to make it work. Help!! Marcus |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Please help | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| date that updates itself daily, plus another formula please?? | Excel Worksheet Functions | |||
| Need to use IF formula with a Date cell | Excel Worksheet Functions | |||
| Date formula | Excel Worksheet Functions | |||
Linear Mode
