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
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

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!
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,129
Messages
5,857,537
Members
431,884
Latest member
Gcmoore63

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top