• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

copy data based on 2 criteria

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.
 

Attachments

  • sample.xlsx
    12.5 KB · Views: 3
Hi !

From your title : easy way to copy data under criterias
is an advanced filter, even by code !

From your post : to just sum better is to use a formula …
 
Trprasad.

Happy to help you...but still trying to understand what you wanted to sumup..Can you give more information...to help.
 
Back
Top