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
|
|