Adding functions to filters

[Rasman]

Hi Guys

I would like to know how i can add several functions to an Excel spreadsheet
that has filters. i would like to have a SUM function that calculates the
total value to each filter, is it possible to have just one function that
calculates the values in each filter.P.S - using Excel 2000

Thanks in advance.

 

[Gary''s Student]

Checkout the =SUBTOTAL() function. It answers the question:

What good is it to have a filter if I can't process the visible cells only?

 

[Bob Phillips]

There are options in SUBTOTAL that cater for filtered ranges, such as

=SUBTOTAL(109,A:A)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)