Hi,

I need to calculate multiple Vlookup data hits.

In my spreadsheet, I need to search for 'UK' in one column, and return the
corresponding values of another column, but calculate the total of these
values if there is more than one 'UK' hit.

Any ideas???