adding figures if they are 30 days old

[Terry252]

Hi

I have a spreadsheet with 2 columns, 1st column has a date and the 2nd column has an amount. What I would like to do is ask excel to only add together those amounts that are 30 days old from todays date. Any ideas?

Thanks

 

[VoG]

Try

=SUMPRODUCT(--(A1:A50=TODAY()-30),B1:B50)

 

[Terry252]

Hi that does not seem to be working, is something missing?

Thanks

 

[VoG]

Do you want to sum the numbers that are exactly 30 days old (the above formula does that) or something else?

 

[Terry252]

I want to sum the numbers that are 30 or older from todays date. so if its the 14/06/2011 I want that in the sum, but not 14/07/2011 if that makes sense?

 

[VoG]

Try

=SUMPRODUCT(--(A1:A50<=TODAY()-30),B1:B50)

 

[Geoff Taylor]

=sumproduct(--(a1:a50<=today()-30),(b1:b50))

Edit - VOG beat me to it.

 

[Terry252]

thanks that worked