software

I have a column quot;Gquot; that contains several dates and another column quot;Kquot; that
contain weights. Additionally, I have two cells (Start Date (B2) and End
Date quot;C2quot;) that I would like to type in different dates which lookup in quot;Gquot;
and sum the weights in quot;Kquot;.

G K
12/12/2005 200
12/16/2005 100
2/11/2005 300
11/15/2005 150

TFTH,
Tom


Try.

=SUMPRODUCT(--(G1:G5gt;B2),--(G1:G5lt;C2),(K1:K5))

HTH

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=499884Try:
=SUMPRODUCT((G2:G10gt;=B2)*(G2:G10lt;=C2),K2:K10)

HTH
JG

quot;Tomquot; wrote:

gt; I have a column quot;Gquot; that contains several dates and another column quot;Kquot; that
gt; contain weights. Additionally, I have two cells (Start Date (B2) and End
gt; Date quot;C2quot;) that I would like to type in different dates which lookup in quot;Gquot;
gt; and sum the weights in quot;Kquot;.
gt;
gt; G K
gt; 12/12/2005 200
gt; 12/16/2005 100
gt; 2/11/2005 300
gt; 11/15/2005 150
gt;
gt; TFTH,
gt; Tom