S
Sandeep Rawat
Hi all,
Can any body solve my problem like i have to add some cells value (COL
E )which are comes under a particular month and which are
corresponding and inbetween of those two dates like fist date of the
month and last date of the month.( eg. comes under COL C and COL D).
take the example of March month the value of Coleumn E should give the
addition of all the cell value which will come or corresponding to COL
C and COL D of dates 01/13/08 and 31/13/08.
ColA COL B COL C COL
D COL E
ID Task Name Actual Start Actual Finish BCWS
1 Receipt of PO 03/13/08 03/14/08 $640.00
2 Receipt of advance 03/14/08 03/18/08 $1,230.00
3 Assigning Project Id 03/20/08 03/20/08 $200.00
4 Preparation - SDP 03/21/08 03/25/08 $960.00
5 Review - SDP 03/24/08 03/25/08 $170.00
6 Project Initiation 03/29/08 04/03/08 $493.00
7 Rework - SDP 04/15/08 04/16/08 $560.00
8 Project startup audit 04/18/08 04/18/08 $80.00
9 Maintain SDP 04/19/08 04/21/08 $200.00
Any help will be appriciated from your side.
Can any body solve my problem like i have to add some cells value (COL
E )which are comes under a particular month and which are
corresponding and inbetween of those two dates like fist date of the
month and last date of the month.( eg. comes under COL C and COL D).
take the example of March month the value of Coleumn E should give the
addition of all the cell value which will come or corresponding to COL
C and COL D of dates 01/13/08 and 31/13/08.
ColA COL B COL C COL
D COL E
ID Task Name Actual Start Actual Finish BCWS
1 Receipt of PO 03/13/08 03/14/08 $640.00
2 Receipt of advance 03/14/08 03/18/08 $1,230.00
3 Assigning Project Id 03/20/08 03/20/08 $200.00
4 Preparation - SDP 03/21/08 03/25/08 $960.00
5 Review - SDP 03/24/08 03/25/08 $170.00
6 Project Initiation 03/29/08 04/03/08 $493.00
7 Rework - SDP 04/15/08 04/16/08 $560.00
8 Project startup audit 04/18/08 04/18/08 $80.00
9 Maintain SDP 04/19/08 04/21/08 $200.00
Any help will be appriciated from your side.