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.

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?


--
Gary''s Student - gsnu200764


"Rasman" wrote:

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.

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)



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