sumif vlookup returns an error

**krunk** · 03-20-2013, 03:59 PM

Hi, I am trying to sum all of the values that return an #n/a based on a vlookup. There might be a better way of doing this but this is where i've started. Hopefully someone can help.

See attached. The cell i am trying to imput the calculation is in D13.

Thanks,
Kali

**JBeaucaire** · 03-20-2013, 04:28 PM

What is your expected result from that sample data?

**Jacc** · 03-20-2013, 04:35 PM

A primitive solution that might work, in cell D13:

Formula:

Please Login or Register  to view this content.

**krunk** · 03-20-2013, 04:43 PM

if it does not find the product ID in the column b (which is only returning the product ID's for those who revenue is greater than 1% of the total revenue (remit) then sum it in column D, so it should result is 3,472. Basically, i want to lump all the products whose revenue <=1% of the total revenue into the "Other" Category.

**JBeaucaire** · 03-20-2013, 04:50 PM

Then I'd recommend the same thing Jacc suggested above.

**krunk** · 03-20-2013, 05:04 PM

And actually this won't work because the formula above is the following: =IFERROR(VLOOKUP(B12,$J$11:$L$27,HLOOKUP(CONCATENATE("2012"&D$10),$L$1:$O$2,2,FALSE),FALSE),"-")

So i was hoping to replace the "-" part with iferror = yes, than sum from column L. Does that make sense?