Adding functions to filters

R

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

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

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