Adding up values when different cell matches

Hi,

I am trying to create a formula that adds up values depending on a match between two value. In the attached example the formula should add up the values from the sheet named "data" in the sheet named "summary" if there is a match between the value in line 2 and the value in column B.

I hope this makes sense.

Rob

If you put this in C3, then drag down and across

Formula:

Please Login or Register  to view this content.