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

Try the following...

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

Hope this helps!

Originally Posted by 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.

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