Adding a column of numbers which fall between today and 30 days ago

[MEATBALL]

I am trying to add a column of numbers with the criteria that the dates those numbers are associated with are from today to 30 days prior.

A.......................B

DATE................NUMBER

1/1/05.................6
12/18/04.............13
12/12/04.............2
12/3/04...............2
11/27/04............15
11/20/04.............3


need to add 6+13+2+2

I have tried SUMIF with different criterium (ie TODAY()-30, EDATE(), etc.) but can't get this to work....please help

Thanks

[Domenic]

Try the following...

=SUMPRODUCT(--(A2:A7>TODAY()-30),B2:B7)

Hope this helps!

I am trying to add a column of numbers with the criteria that the dates those numbers are associated with are from today to 30 days prior.

DATE NUMBER

1/1/05 6
12/18/04 13
12/12/04 2
12/3/04 2
11/27/04 15
11/20/04 3


need to add 6+13+2+2

I have tried SUMIF with different criterium (ie TODAY()-30, EDATE(), etc.) but can't get this to work....please help

Thanks