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

Please try

A27:C27
=A3

D27:F27
=IF($B3,IF($B3<>$B2,SUMIFS(D$3:D$18,$B$3:$B$18,$B3),""),D3)

G27
=IF(B3,LEFT(A3,2),"")

Copy A27:G27 down