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.