Sumproduct and Vlookup

[alirulez]

Hi all

Id be grateful for some help with this problem

I have a table of 50 rows, and each row is populated by a value which in turn has been generated by 5 vlookup formulas all adding the return values up.

So for example B1 would by £740 being the sum of 700+10+10+10+10. Each of the "£700" and "£10" comes from a vlookup formula.

Now at the end of the table (say cell B51), I need a formula which adds up the first vlookup result (so in this example the "£700") for each of the 50 cells in the table.

I thought sumproduct would be the best candidate, but ive become unstuck on how it might be used. Array 1 would be the cell range A1:A50, and Array 2 would be what?

Clear as mud? I look forward to your comments!
Thanks in advance
A

 

[sheetspread]

Sumif is probably the best function to combine with sumproduct here. Unlike vlookup, it can be returned in an array.