VLOOKUP - calculating multiple hits

[carol]

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???

 

[Pranav Vaidya]

Hi Carol

Please tryt he below

=IF(COUNTIF(E2:E10,"UK")>1,SUMIF(E2:E10,"UK",F2:F10),VLOOKUP("UK",E2:F10,2,FALSE))

I assume that UK is listed in col E and corresponding data is in col F

HTH,

 

[JE McGimpsey]

One way:

=SUMIF(A:A,"UK",B:B)