Auto-Filter

B

Brig

Hello. Got a quick auto-filter question on Excel 2003.

I have 2 sheets: Data & Summary

On the Data sheet, I have a table of transactions for a given month. It has
ClientID, Client Info, TransactionAmount, Discounts, Transaction Date

On the Summary sheet, I have just totals for the entire Month.

What I want to do is to be able do a filter or auto-filter on the Data Sheet
for one
specific ClientID. The summary page then should update the calculations for
the
filtered data.

I tried using Auto-Filter in the data sheet but the formulas is still
calculating the entire data sheet.

Is there a way to do this?

Thank you very much in advance.

Brig
 
J

Jim Rech

Most worksheet function do not care whether rows are hidden or not. But the
SUBTOTAL function can be used to ignore hidden rows.
=SUBTOTAL(109,Sheet1!A1:A10) sums only visible rows 1:10.

See Help for more on this function.

--
Jim
| Hello. Got a quick auto-filter question on Excel 2003.
|
| I have 2 sheets: Data & Summary
|
| On the Data sheet, I have a table of transactions for a given month. It
has
| ClientID, Client Info, TransactionAmount, Discounts, Transaction Date
|
| On the Summary sheet, I have just totals for the entire Month.
|
| What I want to do is to be able do a filter or auto-filter on the Data
Sheet
| for one
| specific ClientID. The summary page then should update the calculations
for
| the
| filtered data.
|
| I tried using Auto-Filter in the data sheet but the formulas is still
| calculating the entire data sheet.
|
| Is there a way to do this?
|
| Thank you very much in advance.
|
| Brig
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top