DSUM or COUNTIF with one changing criteria

jedi160

Board Regular
Joined
Jan 8, 2005
Messages
57
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
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

jedi160

Board Regular
Joined
Jan 8, 2005
Messages
57
It worked!

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

Watch MrExcel Video

Forum statistics

Threads
1,114,675
Messages
5,549,367
Members
410,911
Latest member
AniEx
Top