I cannot sum multiple values. I use:
=INDEX(AdNetwork1!B:F,(MATCH(A1,AdNetwork1!B:B,0)-3),3)
but it only finds the first value. As you can see, I am using MATCH with -3 to move up three rows and then move right three columns.
-3
Try something like:
=SUMIF(AdNetwork1!B4:B404,A1,AdNetwork1!D1:D401)
Ranges must be the same size, but can be offset for both column and row.