Sum VLOOKUP in multiple ranges

Hi,

I have a spreadsheet containing a tournament result tables where each years tournament get it's own worksheet (named 2014, 2015, ...). I also have a "Hall of fame" worksheet that sums wins, losses, goals made, etc. for all years but I can't get that part to work. The following formula finds the goals made by a team in 2014:

Please Login or Register  to view this content.

To sum the goals I tried this but it gives me the same result as the one above:

Please Login or Register  to view this content.

Is it possible to do in some other way?

Thanks in advance!

Kind regards
Joakim

Hi. Please read the yellow banner, at the top of the page, and post a sample sheet.

Please try

Please Login or Register  to view this content.

Regards.