Excel Filter then Filter Formula Q 2003

hubba

Board Regular
Joined
Jun 21, 2005
Messages
104
Hi,
I am doing this spreadsheet and need some advice and a formula on the best way to do this part. (Spreadsheet is a Pipeline spreadsheet with sales data)
Okay here we go,
I have a spread with Sales information in it, 2 Sheets, Adam and ATSelect
So I need to now add all the values in Columns K,L,M,N,O that are in NSW only and are Existing only, this would be shown in K437 of Adam in the spreadsheet and this would be for the other states as well VIC, QLD but All Existing.
Column C has the state and column J has the information saying Existing or Prospective

Trying to do it so I just need to import the data from our accounting system directly in to the spreadsheet then it would then update all the information

I know this may not make sense but hopefully it is enough to get some ideas. It is filtering and then filtering again, I tried some other ideas but a little stuck

If you want more information then please let me know, or can email you the spreadsheet?

Thanks
Karl
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
You probably need a Pivot Table, but have a look at other things in the Data menu (Filter ?).
 

Forum statistics

Threads
1,181,730
Messages
5,931,716
Members
436,800
Latest member
abowalid98

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