SUM the data based on multiple matches with different requirements.

Hi,

Need help to calculate and present few data automatically from source. I have attached a few samples of the task. every day I have to work with lots of data and prepare the report according to buyers' requirement. This will help me a lot if I can manage a formula for that.

Conditions are -

• the formula will populate all the line item name and ID as it is.
• If ID=0 then rest of the column Line Item date to clicks will remain the same, and package as "blank"
• If ID is not 0 then it will show the first 2 digits of Line Item Name.
• If there are duplicate IDs of packages on this, then the formula will sum up the impressions to Click in the first match and keep remaining matches

blank