I posted my question here a few days ago, but didnt get even one response,
so I am re-posting and trying to do a better job of explaining what i want.
Im pretty sure this is possible, but dont know exactly how to do it...


Basically, I am trying to come up with a way to match Account Names in
Column A of Sheet2 with Account Names in Column E of Sheet1. If there is a
match there, then match names in Column C of Sheet1 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://www.filehosting.org/file/deta...1WM/sample.xls

In the sample file, you can see that Tommy is responsible for accounts named
€˜BarNone and since BarNone has paid 4,500, Tommy should have 4,500 in
revenue under his name. I have a Sumproduct function that does the matching,
but actually only sums the values on the Row where the reps name is. This
is just how Sumproduct works; it is what it is. Im trying to overcome this
limitation by identifying all account names that each rep is responsible for,
and pick up all the revenue for the rep, according to the Account Name.

Again, in the example I posted, Tommy would have 4500 (other calculated
examples shown in Sheet3). I'm sure it can be done with a UDF. I tried
several preset functions, and just couldnt get Excel to do what I wanted it
to do. Can anyone here understand the logic and supply me with a
user-defined function that will let me do what I want to do? It would
greatly simplify my life for the next several months if I could get this
thing working.

Thanks so much,
Ryan€”



--
RyGuy