DSUM or COUNTIF with one changing criteria

[jedi160]

I want to set up a table with three columns. Column A is labeled Name, Column B is Revenue, Column C is Fees. I want this table to pull data from a bigger database and sum the revenues and fees (in excess of a certain amount) by the name in Column A. I know that I can do this by setting up an expansive criteria table that lists the criteria for the revenue and the fees, copying it for each name, and using a DSUM.

But is there anyway that I can use the Name and one criteria table in a sort of VLOOKUP meets DSUM? That way I could easily copy the formula downward, and it will be much easier for people to work with in the future.

Thanks,
Patrick

 

[Aladin Akyurek]

See for some alternative setups involving d-functions:

http://www.mrexcel.com/board2/viewtopic.php?t=60895

 

[jedi160]

It worked!

It took me a while to figure out how the formula actually functioned, but it worked! Thanks!