Sum

[J Walia]

i have A=Date B= Amount and have 4000 rows i want to total on the base of
date but like that AS of Today 30days result 60days result 120 days result

02/02/2009 100.00
02/03/2009 54.00
02/16/2009 55.00
02/17/2009 103.00
02/18/2009 200.52
02/19/2009 560.65
02/23/2009 123.24


Help me out
Thanks

 

[Fred Smith]

It's not clear what you mean by "AS of Today 30days result ..."

In general, you use Sumproduct for these kind of calculations. See if the
following is of use:
=sumproduct(--(a1:a4000>=today()),--(a1:a4000<=today()+30),(b1:b4000))

Regards,
Fred

 

[Jacob Skaria]

With the number of days in cell c1 try the below


=SUMPRODUCT((A1:A4000>=TODAY()-C1)*B1:B4000)

OR (if you have future data)
=SUMPRODUCT((A1:A4000>=TODAY()-C1)*(A1:A4000<=TODAY())*B1:B4000)