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
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

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
 

Watch MrExcel Video

Forum statistics

Threads
1,123,320
Messages
5,600,946
Members
414,417
Latest member
Nobu

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