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
"Brig" wrote in message
...
| 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
|
|

Thank you vey much.


"Jim Rech" wrote in message
...
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
"Brig" wrote in message
...
| 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
|
|