Find and sum multiple values

Question

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.

SO27914388 question example

+3

conditional excel sum excel-formula worksheet-function

Macb3th 13 jan. '15 at 3:19

source to share

1 answer

pnuts · Accepted Answer · 2015-01-13T03:38:46+0000

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.