| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP - calculating multiple hits
One way:
=SUMIF(A:A,"UK",B:B) In article , carol wrote: 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??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add multiple values in an array based on multiple hits? | Excel Discussion (Misc queries) | |||
| When countdown hits zero | Excel Discussion (Misc queries) | |||
| MS Excel 2003 CTRL+F missing hits | Excel Discussion (Misc queries) | |||
| multiple hits in random sequences | Excel Worksheet Functions | |||
| lookup help with multiple hits | Excel Worksheet Functions | |||
Threaded Mode
