Find and sum multiple values
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
Macb3th
source
to share
1 answer
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.
+3
pnuts
source
to share