Hi,

I am new here, need help from expert to solve the calculation of the report below.....

Need to find out what is the formula to calculate each month figure at the report bottom

P/S. All the figure show at the column below are hiding by formula, which only show the figure belonging to their month.

Date                          Mar                      Feb                    Before Feb
01.01.2011                                                                      1,000.00
03.01.2011                                                                      5,000.00
10.01.2011                                                                      2,250.00
10.02.2011                                          2,500.00
15.02.2011                                             900.00
25.02.2011                                         14,250.00
30.02.2011                                              250.00
01.03.2011            2,100.00
15.03.2011            2,100.00
16.03.2011            1,100.00

----------------------------------------------------------------------------------------
Total                   

Thanks.