Sumif or index formula?

Hello guys,

I have an issue.

In the attached excel sheet, I want to create in cell B10 a formula, which will go through column A, and in case it finds any cell throughout column A that contains "1350", will return the sum of the values found in column J as per the attached excel sheet. In this case, B10 should return $327,181.92

Ideally, I would try index match formula but for some reason it doesn't seem to be working; apparently been trying something wrong

Any ideas on that?

Perfect, thank you both. Sumif works just fine.

I was trying -apparently incorrectly- to use an index match formula.

=index(J2:J7;match("1350";$A2$:$A7$;0))

That would return one single value in case it would trace "1350" throughout column A, but I was trying to return the sum of values based on search "1350"

In other words, could the above be somehow set as a combination of index match formula with a sum?

For example, should it find look up value "1350" from column A, to return the sum of all the respective amounts matched with "1350" in column J

Alright, will try to make clear what I want.

In cell let's say M2, I want a formula that runs through column A, traces "1350" and returns the sum of the values found in column K (in that case $223,445.93)

I was having a hard time on that because I was trying to combine sum and index match formula.

And one more thing I want to make, is to combine two criteria and return again the sum values. For example a formula that runs through column A, traces "1350" and "1300" and returns the sum of values found in column K ( in that case 260,037.93)

I guess concatenate would somehow help here?

Sorry for the hassle!

Originally Posted by AliGW

1350 is not in column J - please provide a more realistic sample of data. You will probably need SUMPRODUCT.

Even tho Bebo's reply covered me completely, there is also a way to do so using sumproduct??