Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum
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 Walia" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum
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) -- Jacob "J Walia" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|