| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel macro/function like VLOOKUP that sums eventual multiple matches
How can I create an Excel command (macro or function) that works like the
VLOOKUP function but sums eventual multiple matches? Example: Sheet1 - before execution: DOG | WHITE HOUSE | YELLOW CAT | GRAY Sheet2 - before execution: HOUSE | 300 DOG | 780 DOG | 200 BALL | 560 Sheet1 - AFTER execution: DOG | WHITE | 980 HOUSE | YELLOW | 300 CAT | GRAY | |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel macro/function like VLOOKUP that sums eventual multiple matches
=SUMIF(Sheet2!A1:A999,A1,Sheet2:B1:B999)
This formula is to be coded in Sheet1, cell C1. Then copied down HTH -- AP "Mary" a écrit dans le message de news: ... How can I create an Excel command (macro or function) that works like the VLOOKUP function but sums eventual multiple matches? Example: Sheet1 - before execution: DOG | WHITE HOUSE | YELLOW CAT | GRAY Sheet2 - before execution: HOUSE | 300 DOG | 780 DOG | 200 BALL | 560 Sheet1 - AFTER execution: DOG | WHITE | 980 HOUSE | YELLOW | 300 CAT | GRAY | |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel macro/function like VLOOKUP that sums eventual multiple matc
Take a look at the sumproduct formula. Here is a link that explains it...
http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH... Jim Thomlinson "Mary" wrote: How can I create an Excel command (macro or function) that works like the VLOOKUP function but sums eventual multiple matches? Example: Sheet1 - before execution: DOG | WHITE HOUSE | YELLOW CAT | GRAY Sheet2 - before execution: HOUSE | 300 DOG | 780 DOG | 200 BALL | 560 Sheet1 - AFTER execution: DOG | WHITE | 980 HOUSE | YELLOW | 300 CAT | GRAY | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup Multiple Matches | Excel Worksheet Functions | |||
| VLOOKUP and multiple matches | Excel Discussion (Misc queries) | |||
| How do I get multiple matches when using the Vlookup function? | Excel Worksheet Functions | |||
| Multiple matches on VLOOKUP | Excel Worksheet Functions | |||
| Vlookup with multiple matches | Excel Programming | |||
![Mary[_10_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
