trprasad78
Member
Hi all,
I need your help,
data has to sum and get output in "outputdata" based on 2 criteria one is Pcode (A column) 2nd one is Revenue/cost (D column)
data has to sum base Pcode with Revenue and pcode with Total cost which i highlighted in data sheet.
FOR the month = Current month (Jan 17)
LE Project end = Next month to end of the project (Feb 17 till date is available)
please refer the outputdata sheet attached.
Please do the needful.
I need your help,
data has to sum and get output in "outputdata" based on 2 criteria one is Pcode (A column) 2nd one is Revenue/cost (D column)
data has to sum base Pcode with Revenue and pcode with Total cost which i highlighted in data sheet.
FOR the month = Current month (Jan 17)
LE Project end = Next month to end of the project (Feb 17 till date is available)
please refer the outputdata sheet attached.
Please do the needful.