Need help with summarizing from a table - dsum?

Jewelzrk

New Member
Joined
Apr 12, 2006
Messages
11
For example, my worksheet is setup like this:

New York California California New York
Company1 Company2 Company3 Company4
Sales 1000000 2000000 Income
Expenses 4444 44444 Income
Cash 1000 500 Balance Sheet
Receivables 5 100 Balance Sheet

I want to create a formula that pulls the subtotal of all balance sheet item amounts for a particular state... so as in this example the total for california would be $11,505

I have a dsum formula for the income vs balance sheet #, but how would I go about breaking it down further by state?



edit: i guess it doesn't show up correctly on the post, but you should be able to see it if you click quote
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
have you thought about using a Pivot Table based off your data table ?
 

Jewelzrk

New Member
Joined
Apr 12, 2006
Messages
11
hmm... I have some experience with pivot tables but I'm looking for something thats easily updated as changes are made and can be linked to
 
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,164,682
Messages
5,838,784
Members
430,568
Latest member
bortey

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