Sum

J

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
 
F

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
 
J

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)
 
Top