Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum between two date
I have a column "G" that contains several dates and another column "K" that
contain weights. Additionally, I have two cells (Start Date (B2) and End Date "C2") that I would like to type in different dates which lookup in "G" and sum the weights in "K". G K 12/12/2005 200 12/16/2005 100 2/11/2005 300 11/15/2005 150 TFTH, Tom |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum between two date
Try. =SUMPRODUCT(--(G1:G5B2),--(G1:G5<C2),(K1:K5)) HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=499884 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum between two date
Try:
=SUMPRODUCT((G2:G10=B2)*(G2:G10<=C2),K2:K10) HTH JG "Tom" wrote: I have a column "G" that contains several dates and another column "K" that contain weights. Additionally, I have two cells (Start Date (B2) and End Date "C2") that I would like to type in different dates which lookup in "G" and sum the weights in "K". G K 12/12/2005 200 12/16/2005 100 2/11/2005 300 11/15/2005 150 TFTH, Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
search for latest date | Excel Worksheet Functions |