I appreciate anyone who can shed some light on this problem for me
Add column B base on the date on Column A the result goes to column C. The Last cell in column C base on 01/01/2015 series must show the answer only[TABLE="width: 500"]
<tbody>[TR]
[TD]01/01/2015[/TD]
[TD]$1.00[/TD]
[TD]Blank[/TD]
[/TR]
[TR]
[TD]01/01/2015[/TD]
[TD]$2.00[/TD]
[TD]Blank[/TD]
[/TR]
[TR]
[TD]01/01/2015[/TD]
[TD]$2.00[/TD]
[TD]Blank[/TD]
[/TR]
[TR]
[TD]01/01/2015[/TD]
[TD]$2.00[/TD]
[TD]Base on 01/01/2015 this cell should show the sum of $7.00[/TD]
[/TR]
[TR]
[TD]01/02/2015[/TD]
[TD]$2.00[/TD]
[TD]Base on 01/01/2015 this cell should show the sum of $2.00[/TD]
[/TR]
[TR]
[TD]01/03/2015[/TD]
[TD]$8.00[/TD]
[TD]Blank[/TD]
[/TR]
[TR]
[TD]01/03/2015[/TD]
[TD]$2.00[/TD]
[TD]Base on 01/01/2015 this cell should show the sum of $10.00[/TD]
[/TR]
[TR]
[TD]01/04/2015[/TD]
[TD]$3.00[/TD]
[TD]Blank[/TD]
[/TR]
[TR]
[TD]01/04/2015[/TD]
[TD]$4.00[/TD]
[TD]Blank[/TD]
[/TR]
[TR]
[TD]01/04/2015[/TD]
[TD]$5.00[/TD]
[TD]Base on 01/01/2015 this cell should show the sum of $12.00[/TD]
[/TR]
</tbody>[/TABLE]
Add column B base on the date on Column A the result goes to column C. The Last cell in column C base on 01/01/2015 series must show the answer only[TABLE="width: 500"]
<tbody>[TR]
[TD]01/01/2015[/TD]
[TD]$1.00[/TD]
[TD]Blank[/TD]
[/TR]
[TR]
[TD]01/01/2015[/TD]
[TD]$2.00[/TD]
[TD]Blank[/TD]
[/TR]
[TR]
[TD]01/01/2015[/TD]
[TD]$2.00[/TD]
[TD]Blank[/TD]
[/TR]
[TR]
[TD]01/01/2015[/TD]
[TD]$2.00[/TD]
[TD]Base on 01/01/2015 this cell should show the sum of $7.00[/TD]
[/TR]
[TR]
[TD]01/02/2015[/TD]
[TD]$2.00[/TD]
[TD]Base on 01/01/2015 this cell should show the sum of $2.00[/TD]
[/TR]
[TR]
[TD]01/03/2015[/TD]
[TD]$8.00[/TD]
[TD]Blank[/TD]
[/TR]
[TR]
[TD]01/03/2015[/TD]
[TD]$2.00[/TD]
[TD]Base on 01/01/2015 this cell should show the sum of $10.00[/TD]
[/TR]
[TR]
[TD]01/04/2015[/TD]
[TD]$3.00[/TD]
[TD]Blank[/TD]
[/TR]
[TR]
[TD]01/04/2015[/TD]
[TD]$4.00[/TD]
[TD]Blank[/TD]
[/TR]
[TR]
[TD]01/04/2015[/TD]
[TD]$5.00[/TD]
[TD]Base on 01/01/2015 this cell should show the sum of $12.00[/TD]
[/TR]
</tbody>[/TABLE]