I need to lookup and sum a row, eg i want to lookup a value in column
A, and add the corresponding row between the say column B and J

so i want to do a vlookup, but instead of returning one value, i want
the sum.

cheers