Add cells in a coloumn from a 2 week period

[Carol-Ann]

Hi! I have a Date and Value Column (A & B) I would like the following result to appear in (C1):

The formula is to take the previous 2 weeks or 14 days from the dates listed in column A. and add the values in column B.

Eg. Feb. 1, 2011 - $35,000
Feb. 14, 2011 - $25,000
Feb. 24, 2011 - $10,000

I would like the formula to only add the sum when the dates are the past 2 weeks (14 days) In this case Feb 14 & 24 would sum $35,000

Thanks.

 

[Weaver]

Assuming your data starts in row 1

=SUMIF($A$1:$A$3,">"&NOW()-14,$B$1:$B$3)

Adjust ranges to suit

HTH