| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF; Two Matches, then Sumproduct of Values
Am trying to come up with a way to match names in Column A of Sheet2 with
names in Column E of Sheet1. If there is a match there, then match names in Column C of Sheet2 with names in Column C of Sheet3, and sum the values, in Column V of Sheet1, that match this name! I uploadad a file to show an example of what I am trying to achieve. Here is a sample: http://rs173.rapidshare.com/files/196921830/sample.xls In the sample file, I was trying to get Cell M2 to be 4500. I'm sure it can be done with a UDF. I tried several preset functions, and went to the Excel - Worksheet Functions group earlier today. A solution still eludes me. Please help! Thanks, Ryan-- -- RyGuy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel sum values if cell matches a value | Excel Worksheet Functions | |||
| If a cell matches a list of values...... | Excel Discussion (Misc queries) | |||
| Two Matches, then Sumproduct of Values | Excel Worksheet Functions | |||
| Add up Values if Find Matches x 2 | Excel Worksheet Functions | |||
| how to get values from different sheet when info. matches? | Excel Worksheet Functions | |||
Linear Mode
